Druide Posted March 31, 2003 Share Posted March 31, 2003 First of all thanks P & G for this HUGE release for MS1 It's time for some BUG TRACKING Trying to install this and while adding spg_alter_table.sql i noticed that this file was not correct ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price, ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_cost; okay i am smart enough to figure this one out i thought but i haven't got the field final_cost so where to put this one ? i added this ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price; that works fine, should the next one be ALTER TABLE customers_basket ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_price; also a little typo in same file ALTER TABLE `countries` ADD `status` TINYINT(1) NOT NULL; this should be ALTER TABLE countries ADD status` TINYINT(1) NOT NULL; to be continued... BTW installing this on tep_snapshot-20030329.zip Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Druide Posted March 31, 2003 Author Share Posted March 31, 2003 another one in install_v08_new_install.txt ADMIN SIDE ---------- Step 1 admin/database_tables.php -------------------------------- add lines below // define new tables for shipping module define('TABLE_SPG_CONFIG', ' spg_config'); define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config_language'); define('TABLE_SPG_MANUAL_INFO', 'spg_man_info'); this should be ADMIN SIDE ---------- Step 1 admin/includes/application_top.php -------------------------------- add lines below // define new tables for shipping module define('TABLE_SPG_CONFIG', ' spg_config'); define('TABLE_SPG_CONFIG_LANGUAGE', ' spg_config_language'); define('TABLE_SPG_MANUAL_INFO', 'spg_man_info'); hmmm lots of error in the ADMIN area, i will collect them in a file and send by email or so.... Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Druide Posted March 31, 2003 Author Share Posted March 31, 2003 Warning: open_basedir restriction in effect. File is in wrong directory in /home/........................./admin/spg_shipping.php on line 339 Warning: Failed opening 'includes/classes/shipping.php' for inclusion and another in admin/spg_blacklist_admin.php?selected_box=shipping 1054 - Unknown column 'p.customers_blacklist' in 'field list' select p.customers_id, p.customers_lastname, p.customers_firstname, p.customers_email_address, p.customers_blacklist from customers p order by p.customers_lastname limit 0, 20 [TEP STOP] and in admin/spg_payment_admin.php?selected_box=shipping 1146 - Table 'ss0329.spg_payment_type' doesn't exist select count(*) as total from spg_payment_type p i stop here for now... the list continues :( Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2003 Share Posted March 31, 2003 go to http://64.255.9.69/oscdownload/ Hello get the latest zip there. all problems reported were fixed this morning. new zip should contain all bugs fixes read the new instructions for the version to be used we have 2 sets of install text : one for new versions and one for users who already have a prior version of our module installed thank you again for taking the time to report install problems Quote Link to comment Share on other sites More sharing options...
Druide Posted March 31, 2003 Author Share Posted March 31, 2003 thanks for the UPDATE :) it seems to work well my my snapshot MS2 03292003 1 question though: can you give an example for this 7. Added page comments admin screen(Test in MS1 but can be cut and pasted in any version since it is only comment field shown) ** You need to add the extras files in zip to be able to use the admin screen Basically we added comment fields to main store pages product_info default shopping cart payment shipping..... This modules allows you to modify comments appearing on the page directly from this screen. there are no extra files in the zip only an empty folder /extras/ I just made this SQL from the errors that i got and by reading the file CREATE TABLE products_comments ( products_id int(11) NOT NULL default '0', products_comments_id int(11) NOT NULL default '0', products_comments_status tinyint(1) NOT NULL default '0', products_comments_name varchar(150) NOT NULL default '', products_comments_desc varchar(255) NOT NULL default '', products_comments_class varchar(100) NOT NULL default '', expires_date datetime default NULL, date_status_change datetime NOT NULL default '0000-00-00 00:00:00', document_last_modified datetime NOT NULL default '0000-00-00 00:00:00' ) TYPE=MyISAM; did i missed anything ? Thanks for the HELP Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
dmGremlin Posted March 31, 2003 Share Posted March 31, 2003 This looks like a really cool and rather massive mod. Thanks for all the work put into this. Can I ask a favor though, could you post a few screenshots so I can get a feel for exactly what this is and how it intigrates...? Thanks -D. M. Quote -D. M. 8) Link to comment Share on other sites More sharing options...
Druide Posted March 31, 2003 Author Share Posted March 31, 2003 there are MANY screens and we dont want to use bandwidth from osC just install it on a clean MS1 or up just 10 minutes and your ready to try it out Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2003 Share Posted March 31, 2003 hello 1. if you download latest latest latest zip from our test site http://64.255.9.69/oscdownload/ we added in sql script info for this table. table is called products_comments in sql file (in fact it takes more time to package that module correctly than to develop it and we forgot to include it in first sql) 2. in the extras : i added as well several examples pages where we added already the comment field quite simple in fact : query is <tr> <td class="smallTextR"><br><br><br> [ <?php $sales_comments_query = tep_db_query("select s.products_comments_desc, s.products_comments_class from " . TABLE_PRODUCTS_COMMENTS . " s where s.products_comments_id= '4' and s.products_comments_status = '1' "); $sales_comments = tep_db_fetch_array($sales_comments_query); echo $sales_comments['products_comments_desc'] ; ?> ] </td></tr> in query s.products_comments_id= '4' , just need to change the id number 4 to whatever id you created in the admin page. we show the id there you can place the comment block wherever you feel in the needed pages. ** note: we created a new class in stylesheet class="smallTextR" for samll bold red text but you can use anything you want Quote Link to comment Share on other sites More sharing options...
dmGremlin Posted March 31, 2003 Share Posted March 31, 2003 Hmm... well my site is already heavily modded. I think it would take more than 10 minutes to do a clean install and then re-install all the mods. Or maybe you're suggesting that I put up a second osC site to test this contribution...? Upon closer inspection it seems that only three original files are touched, though I could be wrong and I hope someone is kind enough to tell me if there are more than this : orders.php in the admin section, and then account_history.php and then account_history_info.php in the catalog section. Perhaps I could just re-install my mods to those three files and then everything would work...? there are MANY screens and we dont want to use bandwidth from osC is it really that large that you couldn't put some screens in a zip file and up them somewhere...? This must be a really friggin large mod... Well I guess I'll just poke through this a bit more and make sure that it won't be too messy to remove if it's not quite right. -D. M. Quote -D. M. 8) Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2003 Share Posted March 31, 2003 the last time we did open an "admin test preview admin" some trashed our test site by changing everything and we waisted a full day reconfiguring our work. thus now we prefer not to waite our time again. Quote Link to comment Share on other sites More sharing options...
Druide Posted April 1, 2003 Author Share Posted April 1, 2003 found another missing field date_status_change my (i hope) now complete table products_comments CREATE TABLE products_comments ( products_comments_id int(11) NOT NULL auto_increment, products_comments_name varchar(40) NOT NULL default '', products_comments_desc longtext NOT NULL, products_comments_class varchar(15) NOT NULL default '', products_id int(11) NOT NULL default '0', products_comments_status tinyint(1) NOT NULL default '0', date_status_change datetime NOT NULL default '0000-00-00 00:00:00', products_comments_image varchar(35) NOT NULL default '', products_comments_order int(2) NOT NULL default '0', last_modified datetime NOT NULL default '0000-00-00 00:00:00', language_id int(3) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', status tinyint(1) NOT NULL default '0', document_last_modified datetime NOT NULL default '0000-00-00 00:00:00', expires_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (products_comments_id) ) TYPE=MyISAM; Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 i have installed the contribution but i cnat figure out how to enable the Payment Methods. here is what is set in my admin section of Shipping by P&G But Admin => Shipping => Payment Admin And this is what my Catalog is showing : I have enabled 2Checkout through Admin => Modules => Payment How do I make the modules to show up at catalog. And I am not sure if everything is working but everything does show up. I can provide you with my admin link to check out. Quote Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 i have installed the contribution but i cnat figure out how to enable the Payment Methods. here is what is set in my admin section of Shipping by P&G But Admin => Shipping => Payment Admin And this is what my Catalog is showing : I have enabled 2Checkout through Admin => Modules => Payment How do I make the modules to show up at catalog. And I am not sure if everything is working but everything does show up. I can provide you with my admin link to check out. Quote Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 Sorry for the repeat postings, its my browser causiong some troubles. the link is http://www.arabianbazaar.com/catalog/Snap1.gif http://www.arabianbazaar.com/catalog/Snap2.gif Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2003 Share Posted April 1, 2003 what you need to do is use the payment admin screen in the shipping module to add a new payment method ie 2checkout in your case. the reason why we did not link directly to the same payment table as OSC was that you are not limited to payment existing in osc for example if you do auctions you can enter western union billpay, billpoint....... as payment even though they are not in OSC it gives you more flexibility same principle for the shipping methods. you may sometines use a shipping method not used in OSc . especially if you enter manual orders. (client could have a shipping account with a carrier and you need to use his carrier not the one in OSC) Quote Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 Alright, But i want to add Western Union Payment Method to my payment methods. I currently have 2Checkout. Quote Link to comment Share on other sites More sharing options...
Farrukh Posted April 1, 2003 Share Posted April 1, 2003 Do you have a screen shot as how Western Union Works. I want to use it as another payment method. Quote Link to comment Share on other sites More sharing options...
pldtm Posted April 1, 2003 Share Posted April 1, 2003 SOME BUGS REPORTED: shipping process: product name, quantity ship, quantity order ... doesn't appear (only sub total appear). TEXT_ALL_ORDERS in status isn't defined manual entry admin: images doesn't exists Question : authorize admin is only for information? customers: problem with some html tags( some code appears under page title Paiement type admin : Is there a link with paiements in use with osc or are they only here for shipping V.8 contrib? order status admin: those are new value or they the one used in osc because i have a problem with language id language admin: can't change status "1054 - Unknown column 'date_status_change' in 'field list'". Is the language id the one use in localization because when i try change language id in editing it doesn't change it C'est tout pour le moment Quote PL DTM ----------------------------------------- Sur un malentendu, ... ?a pourrait marcher Link to comment Share on other sites More sharing options...
Druide Posted April 1, 2003 Author Share Posted April 1, 2003 SOME BUGS REPORTED:language admin: can't change status "1054 - Unknown column 'date_status_change' in 'field list'". Is the language id the one use in localization because when i try change language id in editing it doesn't change it check a few posts back b4 you post :) (i know we all make the same mistakes sometimes ;) ) http://www.oscommerce.com/forums/viewtopic.php...er=asc&start=10 Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
pldtm Posted April 1, 2003 Share Posted April 1, 2003 missing spg_customers table or must we modify all call to spg_customers towards customers?? Pldtm Quote PL DTM ----------------------------------------- Sur un malentendu, ... ?a pourrait marcher Link to comment Share on other sites More sharing options...
Druide Posted April 1, 2003 Author Share Posted April 1, 2003 missing spg_customers table or must we modify all call to spg_customers towards customers?? where did this popped up ? I haven't tested it 100% yet but i'm missing the table also Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
pldtm Posted April 1, 2003 Share Posted April 1, 2003 i saw that this contrib was made by francecontact.com. Is there someone at palmandgardens to explain me in french how to use it. I think i don't understand every menu and how to use it everyday. pldtm Quote PL DTM ----------------------------------------- Sur un malentendu, ... ?a pourrait marcher Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2003 Share Posted April 1, 2003 oui on peut donner des infos en francais egalement mais on a plus de temps le soir (Miami time) pour etre plus interactif tu peux utiliser le live support sur notre site. previens nous avant pour convenir d une heure Quote Link to comment Share on other sites More sharing options...
pldtm Posted April 2, 2003 Share Posted April 2, 2003 ok vers quelle heure chez vous car je crois que quand il est 21h00 a miami, il est 03h00 du matin chez nous pldtm Quote PL DTM ----------------------------------------- Sur un malentendu, ... ?a pourrait marcher Link to comment Share on other sites More sharing options...
teksigns Posted April 2, 2003 Share Posted April 2, 2003 i get this at the top of the page when i click customer admin <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" '"> i also get this when clicking the little green icon to activate the listed customer in a blacklist i guess 1146 - Table 'catalog.table_spg_customers' doesn't exist update TABLE_SPG_CUSTOMERS set customers_blacklist = '1' where customers_id = '2' i customer does exist looking at it . i click the green icon to activate and thats what i get . how do we fix? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.