trollboy Posted July 10, 2004 Share Posted July 10, 2004 Ok, after some heavy hacking and some grey hair.. MS2 is now reading the MS1 DB. I discovered if I do a deault install, then point it at the old ms1 db after the fact, she works just fine. except for the categories.. if I click on one I get: Fatal error: Cannot pass parameter 3 by reference in /home/chaosium/public_html/newcat/includes/modules/product_listing.php on line 13 that's after running the msq_toms2 in the extra's folder.. the "Upgrade" option in the install still gives me a host of errors.. Any help? Link to comment Share on other sites More sharing options...
trollboy Posted July 10, 2004 Author Share Posted July 10, 2004 the categories/products admin page also gives this error: 1054 - Unknown column 'p.products_name' in 'field list' select p.products_id, p.products_name, p.products_quantity, p.products_reorder, p.products_reorder_to, p.products_image, p.products_price, p.products_date_added, p.products_status from products p, products_to_categories p2c where p.products_id = p2c.products_id and p2c.categories_id = '0' order by products_name Link to comment Share on other sites More sharing options...
The_ancient Posted July 10, 2004 Share Posted July 10, 2004 why do you want to use the MS1 database? why cant you updrade using the included upgrade tools? Link to comment Share on other sites More sharing options...
trollboy Posted July 10, 2004 Author Share Posted July 10, 2004 the upgrade tools give me a host of errors, and simply don't work Link to comment Share on other sites More sharing options...
The_ancient Posted July 10, 2004 Share Posted July 10, 2004 well that should tell you ight there something is wrong with your database operating a shop on a alreayd damaged Database is like building a Building ontop of a Damaged Foundation it will be unstable at best ........................ but I am not here to for that.. the awnser your question the Feild "products_name" is not found in the table "products" you have to add that Link to comment Share on other sites More sharing options...
trollboy Posted July 11, 2004 Author Share Posted July 11, 2004 how would it be broken on a WORKING catalog? Is there something I'm missing? if its broke, I certainly want to fix it. Link to comment Share on other sites More sharing options...
The_ancient Posted July 11, 2004 Share Posted July 11, 2004 how would it be broken on a WORKING catalog? Is there something I'm missing? if its broke, I certainly want to fix it. well I dont know for sure that it is broken, but there has to be a reason you can not upgrade Trying to use MS1 database structure on MS2 install will be tedious, since there were alot of changes in the database... they are differant setups, which is why you need an upgadre script if it was just pure php code changes then no upgrade would be required and you would not be getting this error but there were things moves, and fields added that are not in MS1, so you will be getting these types of errors all over the place when trying to use a MS1 databse on a MS2 installation Link to comment Share on other sites More sharing options...
trollboy Posted July 11, 2004 Author Share Posted July 11, 2004 So I guess the question is, what do I do? How do I either fix the db, and/or upgrade it? Link to comment Share on other sites More sharing options...
The_ancient Posted July 11, 2004 Share Posted July 11, 2004 How many Products, Customers and Orders do you have in your Database? as that is really the only thing that need to be Transferred Link to comment Share on other sites More sharing options...
trollboy Posted July 12, 2004 Author Share Posted July 12, 2004 3780 Customers 2121 Orders 501 Products. Link to comment Share on other sites More sharing options...
The_ancient Posted July 12, 2004 Share Posted July 12, 2004 ok, what errors and where did you get them, I thin I rememer reading them before, but everyones questions blends together after awhile... I really think it will be best to figure out why the update did not work, better to fix it now, because it will only get worse as the project develops... Link to comment Share on other sites More sharing options...
trollboy Posted July 12, 2004 Author Share Posted July 12, 2004 My errors where as follows: Upgrade * Address Book * Banners * Categories * Configuration * Currencies * Customers * Images * Languages * Manufacturers * Orders * Products * Reviews * Sessions * Specials * Taxes * Whos Online Status: Update Complete! Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 The database upgrade procedure was successful! Link to comment Share on other sites More sharing options...
The_ancient Posted July 12, 2004 Share Posted July 12, 2004 ok and did the cart give you any error after that... looks like the errors starting occuring as -- I THINK-- the update was going to change some values, the Table look to have been completed right.. but I could be wrong, Link to comment Share on other sites More sharing options...
trollboy Posted July 12, 2004 Author Share Posted July 12, 2004 After the update the site returns no errors, save if you try to go into a category. For an example: refer to: http://server1.chaosium.com/newcat/index.php?cPath=45 Bear in mind I'm planning to delete the install dir after everything's all set up.. hehe paranioa forbids that I delete it just yet. Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 hmm that is a new error for me, never seen that before Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 do you have a table named address_book_to_customers and is there anything in it? Link to comment Share on other sites More sharing options...
trollboy Posted July 13, 2004 Author Share Posted July 13, 2004 yes and its empty. Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 ok, Found the Problem with the Upgrade Let me Work out a Fix Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 comment out line 106 through 110 of install/templates/pages/upgrade_3.php and rerun step 3 Link to comment Share on other sites More sharing options...
trollboy Posted July 13, 2004 Author Share Posted July 13, 2004 only 6 line 45 errors this time, but still no dice.. that table you asked me about before (address_book_to_customers) is gone now though.. line 45 error during upgrade is as follows: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 only 6 line 45 errors this time, but still no dice.. that table you asked me about before (address_book_to_customers) is gone now though.. line 45 error during upgrade is as follows: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/catalog/install/includes/functions/database.php on line 45 that is good iot was suppose to be, as I suspected there were things in your Databse not right that Tables should have had something it what as the Last thing the Upgrade Script Outputted like "Updating Address Book .. done!" ??? Link to comment Share on other sites More sharing options...
trollboy Posted July 13, 2004 Author Share Posted July 13, 2004 Upgrade * Address Book * Banners * Categories * Configuration * Currencies * Customers * Images * Languages * Manufacturers * Orders * Products * Reviews * Sessions * Specials * Taxes * Whos Online Status: Update Complete! Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chaosium/public_html/newcat/install/includes/functions/database.php on line 45 The database upgrade procedure was successful! Link to comment Share on other sites More sharing options...
The_ancient Posted July 13, 2004 Share Posted July 13, 2004 do you have categories_description table? is it empty (should not be) Link to comment Share on other sites More sharing options...
trollboy Posted July 13, 2004 Author Share Posted July 13, 2004 It has 21 records in it.. which is correct. Link to comment Share on other sites More sharing options...
The_ancient Posted July 14, 2004 Share Posted July 14, 2004 do you have table "orders_total" Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.