Bug #14876
closed
Warning: mysql_fetch_assoc() error
0%
Description
After finishing configuration of this installation, I tried to access the front- and backend; both cause this issue. I cannot login or do anything. The backend shows login prompt, frontend is totally unusable.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/drekowski/public_html/t3/typo3_src-3.8.0/t3lib/class.t3lib_db.php on line 741
Ubuntu/Linux 5.04
Mysql 4.1.10a-Debian_2ubuntu0.1-log
PHP 5.0.4-0.6.hoary.1
(issue imported from #M1305)
Updated by David Rekowski over 19 years ago
1 step)
I switched debug on and tried to execute the following SQL-query with phpmyadmin:
"SELECT *
FROM be_sessions,be_users
WHERE
be_sessions.ses_id = '13b59139a3c23914331f9cb8ededbdfc'
AND be_sessions.ses_name = 'be_typo_user'
AND be_sessions.ses_userid = be_users.uid
AND (
be_sessions.ses_iplock='127.0.0.1'
OR be_sessions.ses_iplock='[DISABLED]'
)
AND be_sessions.ses_hashlock=185765706
AND be_users.pid=0 AND be_users.disable=0 AND be_users.deleted=0 AND (be_users.starttime<=1122292039) AND (be_users.endtime=0 OR be_users.endtime>1122292039)"
It complains about missing column ses_iplock:
#14715 - Unknown column 'be_sessions.ses_iplock' in 'where clause'
2 step)
I tried dumping tables.sql to the db via mysql typo3 < tables.sql, which caused
ERROR 1067 (42000) at line 12: Invalid default value for 'uid'
this line reads:
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
what is wrong here?
Updated by Michael Scharkow over 19 years ago
This looks suspiciously similar to #0000416, please look at this first and see if it solves your problem.
Updated by David Rekowski about 19 years ago
Right, it seems to be a duplicate of #14354. I'm sorry for that, I did search the bug database before though.