Welcome to Geeklog, Anonymous Monday, October 03 2022 @ 02:13 pm EDT

Geeklog Forums

1.4.0b1 An SQL error has occurred.


Status: offline

vadertech

Forum User
Full Member
Registered: 05/26/03
Posts: 329
I tried to install on a test site and got the success page but the index.php page gives the error "An SQL error has occurred. Please see error.log for details.". directory.php and spamx admin page also give this error.

Installing plugins gives same error and puts same entry into error.log as below.

Everything else works.

Error log:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) AND (gl_stories.draft_flag = 0) GROUP BY t.sid ORDER BY t.date DESC LIMIT 15' at line 1. SQL in question: SELECT DISTINCT COUNT(*) AS count,gl_stories.title,t.sid FROM gl_trackback AS t,gl_stories WHERE (t.type = 'article') AND (t.sid = gl_stories.sid) AND (t.date >= (DATE_SUB(NOW(), INTERVAL SECOND))) AND (gl_stories.draft_flag = 0) GROUP BY t.sid ORDER BY t.date DESC LIMIT 15

I have ran the install several times with the same results.

check.php passes everything.

EDIT* Though I get the error on plugin installs, they seem to install with the exception of Spamx but give "Data: 1.x, Code: N/A Update!" message.
GeekLog Hosting, Installations and Upgrades - WWW.AWEHOST.COM - Hosting starts @ only $4.95/mo.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
You seem to be missing $_CONF['newtrackbackinterval'] in your config.php

bye, Dirk
 Quote

Status: offline

vadertech

Forum User
Full Member
Registered: 05/26/03
Posts: 329
Quote by Dirk: You seem to be missing $_CONF['newtrackbackinterval'] in your config.php

bye, Dirk


That did it. Weird I thought I used the config.php that came with 1.4.0b1.

Regardless, thanks.
GeekLog Hosting, Installations and Upgrades - WWW.AWEHOST.COM - Hosting starts @ only $4.95/mo.
 Quote

All times are EDT. The time is now 02:13 pm.

  • 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