Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 05:40 am EDT

Geeklog Forums

Serious problem with Geeklog 1.4.0


Status: offline

Richard Hirs

Forum User
Newbie
Registered: 04/23/06
Posts: 2
dizzy
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?
 Quote

Status: offline

NeoNecro

Forum User
Regular Poster
Registered: 02/07/04
Posts: 90
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
 Quote

Status: offline

Richard Hirs

Forum User
Newbie
Registered: 04/23/06
Posts: 2
Yes it seems I have a GL 1.3.11 database with a GL 1.4.0sr2 installation
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
So do what NeoNecro said: Run the install script in upgrade mode. You may want to read the upgrade instructions ...

bye, Dirk
 Quote

Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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
 Quote

All times are EDT. The time is now 05:40 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content