KiLLaH Posted April 13, 2004 Posted April 13, 2004 Hello, Im currently trying to transfer a database with such as orders from 2.1 to 2.2 MS2, but there seems to be a problem with the orders (theres over 1000). I get this error when i check the orders from admin site: 1054 - Unknown column 'orders_status_id' in 'field list' select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '2485' order by date_added [TEP STOP] Anyone who is familiar with this and know the way to sort out things. I have added the missing fields for billing and company in the table. Thanks. //Maz
elect Posted April 13, 2004 Posted April 13, 2004 Hello, Im currently trying to transfer a database with such as orders from 2.1 to 2.2 MS2, but there seems to be a problem with the orders (theres over 1000). I get this error when i check the orders from admin site: 1054 - Unknown column 'orders_status_id' in 'field list' select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '2485' order by date_added [TEP STOP] Anyone who is familiar with this and know the way to sort out things. I have added the missing fields for billing and company in the table. Thanks. Hey I tried to do the same thing, however I didn't get very far. Here is the link to thread I started topic. Unless you are more successful then me, the only solution I see is re-entetering info into new db by hand. Hope this helps, elect
Mark Evans Posted April 13, 2004 Posted April 13, 2004 How did you upgrade? If you are moving from 2.1 to 2.2 then you can use the upgrade in the install module. Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
vcache Posted April 14, 2004 Posted April 14, 2004 One idea (unless the actual database structure itself has changed) would be to use phpmyadmin to create a .sql file and then import it into the new database.. may be totally off-track there but was just a thought Contribs added: AdminLogin-Catalog With Images-Credit Class/Gift Voucher-CoolMenu EasyPopulate-LoginBox-Paypal Shopping Cart IPN-PDF Catalogs Product Listing In Columns - Image Strip -- ...the young jedi said to his master "you want me to do WHAT?"
Mark Evans Posted April 14, 2004 Posted April 14, 2004 There have been DB changes which is why we provide the automatic db upgrade script ;) Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
elect Posted April 14, 2004 Posted April 14, 2004 I have tried to migrate from 2.1 to 2.2m2 these where the stepts I took. logged in as the root on to the server ran the following script ./mysqldiff.pl --host=localhost --user=yourdbusername --pasword=yourdbpassword 2.1_db 2.2m2_db the script executed and altered tables in 2.1 db dumbed the data and struct of the 2.1 db into a file and then inserting that data and struct from file into 2.2m2 db. the result was a sql error around address_book table This wher I got stuck.
KiLLaH Posted May 10, 2004 Author Posted May 10, 2004 Thanks alot for the replies, i did try to import the old database but i ended up with sevearl many errors than i expected. Isnt there a importing script so it adds the missing fields? Because theres a few hundres orders/customers in the database which is not easy at all. //Maz
KiLLaH Posted May 10, 2004 Author Posted May 10, 2004 This is what happend when i used the upgrade function on oscommerce install. Upgrade Warning: set_time_limit(): Cannot set time limit in safe mode in /srv/www/htdocs/web1/html/install/includes/functions/general.php on line 47 * 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 /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /srv/www/htdocs/web1/html/install/includes/functions/database.php on line 45 The database upgrade procedure was successful! Suddenly my admin area is acting like this now: Warning: main(includes/languages/.php): failed to open stream: No such file or directory in /srv/www/htdocs/web1/html/admin/includes/application_top.php on line 130 Fatal error: main(): Failed opening required 'includes/languages/.php' (include_path='.:/usr/share/php') in /srv/www/htdocs/web1/html/admin/includes/application_top.php on line 130 //Maz
Guest Posted May 10, 2004 Posted May 10, 2004 Here is your problem: Warning: set_time_limit(): Cannot set time limit in safe mode PHP is running in safe mode :) Set safe_mode=Off in php.ini and restart your server Matti
Guest Posted May 12, 2004 Posted May 12, 2004 Here is your problem: Warning: set_time_limit(): Cannot set time limit in safe mode PHP is running in safe mode :) Set safe_mode=Off in php.ini and restart your server Matti How do i do that??
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.