Forum Subject: An SQL error has occurred. Please see error.log

Posted on: 11/15/10 11:19am
By: hansf

I inherited a site that was running Geeklog 1.4.0sr2 and I am trying to upgrade to 1.7.1. I get through all phases of upgrading the database but end up with the following message:

Fatal error: An SQL error has occurred. Please see error.log for details. in /Volumes/Storage/web/foulger.clemson.edu/system/databases/mysql.class.php on line 260

If I look in the error log I see the following:

Mon Nov 15 11:13:11 2010 - 1054: Unknown column 'created' in 'field list'. SQL in question: SELECT sp_id,sp_title,sp_content,sp_format,created,modified,sp_hits,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 (draft_flag = 0) AND (template_flag = 0) AND (sp_where = 0) AND ((sp_tid = 'none' OR (sp_tid = 'all') AND (perm_anon >= 2) ORDER BY sp_id

I am an occasional unix user and would rate myself capable enough to be dangerous. I ran through all the mysql admin check and repairing issues and believe the problem is somewhere in the static page table with regard to the staticpage plugin.

Any help would be appreciated.

hans

Re: An SQL error has occurred. Please see error.log

Posted on: 11/15/10 12:32pm
By: Laugh

Hmm, It looks like your staticpage plugin didn't upgrade its database table correctly. The staticpage plugin now has a "created" and "modified" date fields instead of just "sp_date".

What version of the staticpage plugin does it say you are running? (check Plugins under Admin Only block).

To fix this I will probably also need a list of the table columns for your staticpage table in your Geeklog database.

Tom

Re: An SQL error has occurred. Please see error.log

Posted on: 11/15/10 01:00pm
By: hansf

Tom,

Thanks for the reply and interest. I am using

staticpages plugin: 1.4.2 geeklog: 1.4.0

If you tell me what mysql command I should use I'll copy in the output from mysql.

Thanks,
hans

Re: An SQL error has occurred. Please see error.log

Posted on: 11/15/10 06:19pm
By: Laugh

In plugins try disabling the staticpage plugin and then try the upgrade and let me know what happens.

Tom

Re: An SQL error has occurred. Please see error.log

Posted on: 11/16/10 11:42am
By: hansf

here is the column info from gl_staticpage:


mysql> show columns from gl_staticpage;
+----------------+-----------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+-----------------------+------+-----+---------------------+-------+
| sp_id | varchar(40) | | PRI | | |
| sp_uid | mediumint(8) | | MUL | 1 | |
| sp_title | varchar(128) | | | | |
| sp_content | text | | | | |
| sp_hits | mediumint(8) unsigned | | | 0 | |
| sp_date | datetime | | MUL | 0000-00-00 00:00:00 | |
| sp_format | varchar(20) | | | | |
| sp_onmenu | tinyint(1) unsigned | | MUL | 0 | |
| sp_label | varchar(64) | YES | | NULL | |
| commentcode | tinyint(4) | | | 0 | |
| group_id | mediumint(8) unsigned | | | 1 | |
| owner_id | mediumint(8) unsigned | | | 1 | |
| perm_owner | tinyint(1) unsigned | | | 3 | |
| perm_group | tinyint(1) unsigned | | | 2 | |
| perm_members | tinyint(1) unsigned | | | 2 | |
| perm_anon | tinyint(1) unsigned | | | 2 | |
| sp_centerblock | tinyint(1) unsigned | | MUL | 0 | |
| sp_help | varchar(255) | YES | | | |
| sp_tid | varchar(20) | | MUL | none | |
| sp_where | tinyint(1) unsigned | | MUL | 1 | |
| sp_php | tinyint(1) unsigned | | | 0 | |
| sp_nf | tinyint(1) unsigned | YES | | 0 | |
| sp_inblock | tinyint(1) unsigned | YES | | 1 | |
| postmode | varchar(16) | | | html | |
+----------------+-----------------------+------+-----+---------------------+-------+
24 rows in set (0.00 sec)


as to turing off the staticpage plugin...how do i do this?

Thanks for your help,
hans

Re: An SQL error has occurred. Please see error.log

Posted on: 11/16/10 12:52pm
By: Laugh

To disable a plugin, goto the Admin Only block and then click plugins. A list of plugins will come up. I can't recall if Geeklog 1.4.0 has an enable checkbox in the list but if it isn't there you can click on the edit icon for the plugin and disable it (not uninstall) from that point.

I will take a look at the install script for the staticpage plugin and get back to you with anything I find.

Re: An SQL error has occurred. Please see error.log

Posted on: 11/16/10 10:09pm
By: hansf

I can't get the 1.4.0 site to run anymore so that is out. I tried just dropping the staticpage table to no avail. I am at a loss. Can I manually run the database through a script to convert it? Obviously the automated updating from 1.4.0 to 1.7.1 does not work very well. Any suggestions would be appreciated..this is getting serious.I cant get the site running even to get to the configuration to turn the plugin off. Help.

hans

Re: An SQL error has occurred. Please see error.log

Posted on: 11/17/10 02:01am
By: Dirk

Here's an alternate description for disabling a plugin: http://wiki.geeklog.net/index.php/Disabling_a_plugin[*1]

HTH

bye, Dirk

Re: An SQL error has occurred. Please see error.log

Posted on: 11/17/10 08:15am
By: Laugh

From the table you show it looks like your staticpage plugin was updated to at least version 1.5.0 and possibly version 1.5.1 (there were no table changes in 1.5.1). Looking over the code I don't see anything that should have prevented a further upgrade to the latest staticpage version.

For me to figure this out I will need to see more of the DB. Why don't you send me a private email.

Tom