The secure CMS.
Forum Menu
Resources
Topics
- Home
- Development (317)
- Geeklog (209)
- Plugins (111)
- Themes (2)
- News (387)
- Announcements (248)
- Geeklog.net (31)
- Security (76)
- Spam (11)
- Summer of Code (26)
User Functions
Events
There are no upcoming events
What's New
Stories
No new storiesComments last 2 weeks
No new commentsTrackbacks last 2 weeks
No new trackback commentsLinks last 2 weeks
No recent new linksNEW FILES last 14 days
No new filesWelcome to Geeklog Sunday, May 19 2013 @ 03:45 PM EDT
|
||||||||
 |
Forum Index > Support > Installation Support |
New Topic
|
Post Reply
|
 Upgrade 1.40 to 1.41 - MySQL error |
|||
| xardoz |
|
||||||
  Regular Poster   Status: offline  Registered: 02/24/04 Posts: 98 |
I'm having problems upgrading from 1.40 to 1.41. - it fails, generating an SQL error after I hit the UPGRADE button.
From the error log: PHP Formatted Code Thu 03 May 2007 12:39:21 EDT - 1054: Unknown column 'sp_help' in 'field list'. SQL in question: SELECT sp_id,sp_title,sp_content,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_id Thu 03 May 2007 12:41:13 EDT - 1146: Table 'attackgl.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG There's several more lines almost (if not completely) identical the first one, above what I've posted here. I think they are from someone trying to access part of the site while I'm in the middle of the upgrade, but I included one for reference. Thanks in advance for any help! UPDATE - I restored the DB from backup and tried again, this time using my superuser name and password, thinking that maybe the standard user (which always worked before) might not have sufficient rights. However, it gave me exactly the same error: PHP Formatted Code Thu 03 May 2007 12:41:13 EDT - 1146: Table 'attackgl.WP_BB_LOG' doesn't exist. SQL in question: SELECT COUNT(*) FROM WP_BB_LOG |
||||||
|
|||||||
| Dirk |
|
||||||
 Admin  Status: offline  Registered: 01/12/02 Posts: 13027 |
The second error is because you forgot to add the extra line for Bad Behavior to your lib-common.php. Please refer to the installation instructions of that plugin.
The first error looks suspiciously like you didn't run the database upgrade. bye, Dirk |
||||||
|
|||||||
| xardoz |
|
||||||
|
Regular Poster Status: offline Registered: 02/24/04 Posts: 98 |
Thanks, Dirk. I'll take a look at the Bad Behavior stuff - I know I didn't add anything to the 1.41 lib-common.php (except the path to config.php, of course).
I'm certain that the first error is from someone trying to access the site either while I was uploading 1.41, or just afterwards, but before I had done the db upgrade. |
||||||
|
|||||||
| xardoz |
|
||||||
|
Regular Poster  Status: offline Registered: 02/24/04 Posts: 98 |
That fixed it - Thanks, Dirk!
|
||||||
|
|||||||
05/03/07 12:56PM (Read 764 times)
Quote| Content generated in: 1.78 seconds |
|
|
|
