Posted on: 04/23/06 04:05am
By: Richard Hirs
Dear people,
I have a serious problem I made a mistake and deleted my whole website (GL 1.3.11) no problem was I thinking, I have a copy of the database and this is maybe a good time to install the new version also.
I downloaded the latest version of Geeklog (1.4.0sr2) and had it working not long after, the problem is that I now that I restored the database and changed the config.php to point to the right database I get this “An SQL error has occurred. Please see error.log for details.” error.
Looking in my log file I see this
Sun 23 Apr 2006 03:18:15 EDT - 1054: Unknown column 'hits' in 'field list'. SQL in question: UPDATE gl_events SET hits = hits + 1 WHERE eid = '2006022303424728'
Sun 23 Apr 2006 03:30:43 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:30:56 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:31:34 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:32:33 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'food')
Sun 23 Apr 2006 03:35:43 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:35:49 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'Entertainment')
Sun 23 Apr 2006 03:36:02 EDT - 1054: Unknown column 'hits' in 'field list'. SQL in question: UPDATE gl_events SET hits = hits + 1 WHERE eid = '2006022303424728'
Sun 23 Apr 2006 03:36:15 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'General')
Sun 23 Apr 2006 03:36:49 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'Entertainment')
Sun 23 Apr 2006 03:36:56 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'Entertainment')
Sun 23 Apr 2006 03:36:57 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'Entertainment')
Sun 23 Apr 2006 03:38:17 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:18 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:19 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:20 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:21 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:22 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:23 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:23 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:24 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:25 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:26 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:27 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:29 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:29 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:30 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:38:31 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:40:21 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:42:00 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'General')
Sun 23 Apr 2006 03:47:22 EDT - 1054: Unknown column 'hits' in 'field list'. SQL in question: UPDATE gl_events SET hits = hits + 1 WHERE eid = '20050618132657729'
Sun 23 Apr 2006 03:48:17 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
Sun 23 Apr 2006 03:57:14 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'Entertainment')
Sun 23 Apr 2006 03:58:28 EDT - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all') OR (header_tid = 'technology')
Maybe my GL SQL database is in a other format, but how to convert to the new 1.4.0sr2 format?
Serious problem with Geeklog 1.4.0
Posted on: 04/23/06 05:59am
By: NeoNecro
So, you have a 1.3.11 database on your 1.4.0 site?
You should update your installation by running the install script and chose update database for the install type.
Serious problem with Geeklog 1.4.0
Posted on: 04/23/06 06:50am
By: Richard Hirs
Yes it seems I have a GL 1.3.11 database with a GL 1.4.0sr2 installation
Serious problem with Geeklog 1.4.0
Posted on: 04/23/06 10:17am
By: Dirk
So do what NeoNecro said: Run the install script in upgrade mode. You may want to read the
upgrade instructions[*1] ...
bye, Dirk
Serious problem with Geeklog 1.4.0
Posted on: 05/30/06 01:26am
By: etegration
nice post, googled for the error and i was brought here and it solve it! thanks all again.