Geeklog Forums

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?

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.

---

dimis-site.be

Yes it seems I have a GL 1.3.11 database with a GL 1.4.0sr2 installation

So do what NeoNecro said: Run the install script in upgrade mode. You may want to read the upgrade instructions ...

bye, Dirk

nice post, googled for the error and i was brought here and it solve it! thanks all again.

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com