A couple of weeks ago I upgraded wsnlinks from 3.4.3 to 4.0.25 and then to 4.0.28, which went relatively well with a couple of problems which were overcome with the help of this forum (see www.webmastersite.net/forum...Upgrade_problems-7372.html). Since then, the directory seemed to be working fine... except that the sites still register as running version 4.0.25 even after running the 4.0.28 upgrade, as I'd noted previously.
Today I decided to go ahead and upgrade once again to 4.0.31.
I uploaded all files except the templates and integration directories to one of the 3 WSNlinks sites I have, and ran upgrade.php. The script ran without any error messages, but when I logged in to my directory and afterwards and started working with it, wanting to delete some entries, I got blank pages after pressing the delete button. Turning debug on still gives me a blank page after pressing "delete" and when I returned to the admin panel or directory, the entries that I tried to delete still appeared.
I had to go into the phpmyadmin and manually delete the entries. Once there I looked more closely at the database itself I realized that many of the tables that should be there were missing.
The tables the database contain are only these: wsnlinks_calendar wsnlinks_categories wsnlinks_comments wsnlinks_email wsnlinks_invites wsnlinks_links wsnlinks_markup wsnlinks_membergroups wsnlinks_members wsnlinks_pm wsnlinks_ratings wsnlinks_searches wsnlinks_sessions wsnlinks_settings wsnlinks_switches wsnlinks_trader
The databases of other sites (which were upgraded to 4.0.25 or 4.0.28 but on which I haven't run the 4.0.31 upgrade) contain the above tables plus attachments, crons, helpcategory, helpitem, im and modlog.
I ran the upgrade script several times. It always goes through everything fine, saying that the upgrade was successful and with no errors. Yet the database is incomplete and it seems it was like that before I did this last upgrade, since my database backup, which I did just before the upgrade, is also the same way. I suspect that the database wasn't properly upgraded on one of the two prior upgrades done recently.
What do you recommend I do to correct this? Would there be a way of constructing a blank database per version 4.0.31 and importing my current settings, categories and links into it (I don't use the member system, comments, etc.). Right now my site is visible and the information looks correct to the public, but the back end isn't working and I'm afraid of losing all my link data.
If I just created the missing tables by hand in phpmyadmin, and run the install script again, would that possibly work or would it screw things up even more?
I went ahead and created the missing tables by hand and ran the upgrade script again. Everything went smoothly and no more blank pages... Don't quite understand why the database was missing those tables though, when no error messages were generated to that effect during the upgrades.
Tables would not be added if you have them specified in your config.php somehow -- though I can't imagine how you would. When you remove those table declarations from config.php then upgrade.php will add the tables.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Upgrade problems
Member
Usergroup: Customer
Joined: Dec 27, 2003
Total Topics: 9
Total Comments: 18
A couple of weeks ago I upgraded wsnlinks from 3.4.3 to 4.0.25 and then to 4.0.28, which went relatively well with a couple of problems which were overcome with the help of this forum
(see www.webmastersite.net/forum...Upgrade_problems-7372.html). Since then, the directory seemed to be working fine... except that the sites still register as running version 4.0.25 even after running the 4.0.28 upgrade, as I'd noted previously.
Today I decided to go ahead and upgrade once again to 4.0.31.
I uploaded all files except the templates and integration directories to one of the 3 WSNlinks sites I have, and ran upgrade.php. The script ran without any error messages, but when I logged in to my directory and afterwards and started working with it, wanting to delete some entries, I got blank pages after pressing the delete button. Turning debug on still gives me a blank page after pressing "delete" and when I returned to the admin panel or directory, the entries that I tried to delete still appeared.
I had to go into the phpmyadmin and manually delete the entries. Once there I looked more closely at the database itself I realized that many of the tables that should be there were missing.
The tables the database contain are only these:
wsnlinks_calendar
wsnlinks_categories
wsnlinks_comments
wsnlinks_email
wsnlinks_invites
wsnlinks_links
wsnlinks_markup
wsnlinks_membergroups
wsnlinks_members
wsnlinks_pm
wsnlinks_ratings
wsnlinks_searches
wsnlinks_sessions
wsnlinks_settings
wsnlinks_switches
wsnlinks_trader
The databases of other sites (which were upgraded to 4.0.25 or 4.0.28 but on which I haven't run the 4.0.31 upgrade) contain the above tables plus attachments, crons, helpcategory, helpitem, im and modlog.
I ran the upgrade script several times. It always goes through everything fine, saying that the upgrade was successful and with no errors. Yet the database is incomplete and it seems it was like that before I did this last upgrade, since my database backup, which I did just before the upgrade, is also the same way. I suspect that the database wasn't properly upgraded on one of the two prior upgrades done recently.
What do you recommend I do to correct this? Would there be a way of constructing a blank database per version 4.0.31 and importing my current settings, categories and links into it (I don't use the member system, comments, etc.). Right now my site is visible and the information looks correct to the public, but the back end isn't working and I'm afraid of losing all my link data.
Member
Usergroup: Customer
Joined: Dec 27, 2003
Total Topics: 9
Total Comments: 18
If I just created the missing tables by hand in phpmyadmin, and run the install script again, would that possibly work or would it screw things up even more?
Member
Usergroup: Customer
Joined: Dec 27, 2003
Total Topics: 9
Total Comments: 18
I went ahead and created the missing tables by hand and ran the upgrade script again. Everything went smoothly and no more blank pages... Don't quite understand why the database was missing those tables though, when no error messages were generated to that effect during the upgrades.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Tables would not be added if you have them specified in your config.php somehow -- though I can't imagine how you would. When you remove those table declarations from config.php then upgrade.php will add the tables.