FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » SQL Error after installation
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
SQL Error after installation [message #28406] Sun, 23 October 2005 11:04 Go to previous message
Cower   Sweden
Messages: 5
Registered: October 2005
Karma:
Junior Member
I've just installed v 2.7.2 (fresh install), and index.php gives:
Quote:

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/lair/forum-data/include/core.inc on line 184

PHP version: 4.3.10
Database: MySQL 4.0.24
Webserver: Apache 1.3.33

The logfile for MySQL contains (for one attempt):
051023 12:45:40       6 Connect     lair_forum@localhost on 
                      6 Init DB     lair_forum
                      6 Query       SELECT
                s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id,
                t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.them
e, t.pspell_lang, t.theme_opt,
                u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_r
ead, u.cat_collapse_status, u.users_opt,
                u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader
_list, u.email, u.login, u.sq, u.ban_expiry
        FROM fud26_ses s
                INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id>2000000000
 THEN 1 ELSE s.user_id END)
                INNER JOIN fud26_themes t ON t.id=u.theme
        WHERE s.ses_id='6cd5887baf1799833209c550d4191d36'
                      6 Query       SELECT id FROM fud26_users WHERE (users_opt 
& 131072)=0 AND join_date<1129459540 AND posted_msg_count=0 AND last_visit<11294
59540 AND id!=1 AND (users_opt & 1048576)=0
                      6 Query       UPDATE fud26_ses SET sys_id='94fa3c5c28bd1ea
68f09923d6c24375c', forum_id=0, time_sec=1130064340, action='Login Form', return
to=returnto WHERE id=1
                      6 Query       SELECT VERSION()
                      6 Quit       
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Duplicate category displays
Next Topic: problem after step 5
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 02:47:29 GMT 2024

Total time taken to generate the page: 0.04154 seconds