|
Ok, Here's the details on my upgrading of the SQL from 1.0 to 3.2
First, I renamed usergroups to rp_usergroups. It really seems to need that.
Here are the errors received on the way:
1.0 to 2.0
None
2.0 to 2.1
None
2.1 to 2.52
None
2.5x to 2.8
Performing MySQL command: DROP TABLE rp_stylesheet ... Error: Unknown table 'rp_stylesheet'
Performing MySQL command: ALTER TABLE rp_iponline DROP INDEX userid ... Error: Can't DROP 'userid'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX approved ... Error: Can't DROP 'approved'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX date ... Error: Can't DROP 'date'. Check that column/key exists
2.8x to 2.9
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 645
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 646
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 647
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 648
2.px to 3.0
Performing MySQL command: ALTER TABLE rp_usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL, ADD uplimit INT(3) DEFAULT '0' NOT NULL ... Error: Table 'tdpri.rp_usergroups' doesn't exist
erforming MySQL command: ALTER TABLE rp_categories ADD thumbnail INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'thumbnail'
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 810
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 811
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 812
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 813
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 814
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 815
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 816
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 817
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 818
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 819
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 820
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 821
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 822
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 823
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 824
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 825
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 826
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 827
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 828
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 829
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 830
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 831
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 832
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 833
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 834
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 835
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 836
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 837
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 838
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 839
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 840
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 841
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 842
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 843
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 844
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 845
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 846
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 847
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 848
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 849
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 850
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 851
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 852
Warning: unlink() failed (No such file or directory) in /home/www/tdpri.com/reviewpost/upgrade.php on line 853
3.0x to 3.1 None
upgrade to 3.11
None
|