Webmastersite.net
Register Log In

Upgrade problems
database not upgraded

Comments on Upgrade problems

Zihrena
Member

Usergroup: Customer
Joined: Dec 27, 2003

Total Topics: 9
Total Comments: 18
Zihrena
Posted Jun 12, 2007 - 3:48 PM:

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.

Zihrena
Member

Usergroup: Customer
Joined: Dec 27, 2003

Total Topics: 9
Total Comments: 18
Zihrena
Posted Jun 13, 2007 - 9:49 AM:

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?
Zihrena
Member

Usergroup: Customer
Joined: Dec 27, 2003

Total Topics: 9
Total Comments: 18
Zihrena
Posted Jun 13, 2007 - 10:29 AM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 14, 2007 - 1:13 AM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.