English version - [Other] SQL Error : 1146 Table 'xxx.SESSIONS_TABLE' doesn't
evilmc - 21-03-2009, 20:41
Temat postu: [Other] SQL Error : 1146 Table 'xxx.SESSIONS_TABLE' doesn't
| Kod: | phpBB by Przemo : Kriticna greška
Error doing DB query userdata row fetch
DEBUG MODE
SQL Error : 1146 Table 'serbianu_forum.SESSIONS_TABLE' doesn't exist
SELECT u.*, s.* FROM (SESSIONS_TABLE s, USERS_TABLE u) WHERE s.session_id = '2948a3466823cb8721b7849a804e52c3' AND u.user_id = s.session_user_id
Line : 637
File : sessions.php |
www.serbianunderground.com/forum/
please help
lui754 - 21-03-2009, 20:53
http://www.przemo.org/php...+table+sessions
SQL
| Kod: | CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id),
KEY session_time (session_time)
); |
evilmc - 21-03-2009, 20:59
| Cytat: | Error
SQL query:
CREATE TABLE phpbb_sessions(
session_id char( 32 ) DEFAULT '' NOT NULL ,
session_user_id mediumint( 8 ) DEFAULT '0' NOT NULL ,
session_start int( 11 ) DEFAULT '0' NOT NULL ,
session_time int( 11 ) DEFAULT '0' NOT NULL ,
session_ip char( 8 ) DEFAULT '0' NOT NULL ,
session_page int( 11 ) DEFAULT '0' NOT NULL ,
session_logged_in tinyint( 1 ) DEFAULT '0' NOT NULL ,
session_admin tinyint( 2 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( session_id ) ,
KEY session_user_id( session_user_id ) ,
KEY session_id_ip_user_id( session_id, session_ip, session_user_id ) ,
KEY session_time( session_time )
);
MySQL said: Documentation
#1050 - Table 'phpbb_sessions' already exists |
lui754 - 21-03-2009, 21:00
| Kod: | | DROP TABLE phpbb_sessions ; |
and
| Kod: | CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id),
KEY session_time (session_time)
); |
evilmc - 21-03-2009, 21:03
| lui754 napisał/a: | | Kod: | | DROP TABLE phpbb_sessions ; |
and
| Kod: | CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id),
KEY session_time (session_time)
); |
|
not wirking.
lui754 - 21-03-2009, 21:06
| Kod: | | REPAIR TABLE phpbb_sessions; |
and
| Kod: | | REPAIR TABLE 'phpbb_users'; |
evilmc - 21-03-2009, 21:10
| lui754 napisał/a: | | Kod: | | REPAIR TABLE phpbb_sessions; |
and
| Kod: | | REPAIR TABLE 'phpbb_users'; |
|
done, but still does not work.
lui754 - 21-03-2009, 21:13
| Cytat: | | 1146 Table 'serbianu_forum.USERS_TABLE' doesn't exist |
sorry i am not english.
Brak table phpbb_users. Wgraj backup sql.
link: http://www.przemo.org/php...pic.php?t=12224
MagicalFire - 21-03-2009, 21:35
| lui754 napisał/a: | | Brak table phpbb_users. Wgraj backup sql. |
None phpbb_users table. Upload backup sql.
evilmc - 22-03-2009, 22:35
| MagicalFire napisał/a: | | None phpbb_users table. Upload backup sql. |
okey. my host company have 1 week old backup.
but i have this
forum/db/db_backup
2009-03-20_db_backup_phpbb_bjzg7o4glpgp8ng103igk8v5.sql
2009-03-21_db_backup_phpbb_oxhgf2k17tyzg2k4epfxpodp.sql
I have 2 backup file, can this backup to work?
one backup file has 545 MB...
MagicalFire - 22-03-2009, 22:42
did not really understand
what wrote
feel free to download copies of
or upload it to the same table phpbb_users
Seraphe - 24-03-2009, 23:22
| evilmc napisał/a: | | 2009-03-21_db_backup_phpbb_oxhgf2k17tyzg2k4epfxpodp.sql |
This one is from 21th of March, try this one.
Btw. I'm wondering... What have You done with Your phpbb_users table?
And remember - if you want to make backup, uncheck Copy phpbb_read_history table and Copy phpbb_search table option.
evilmc - 27-03-2009, 21:29
| Kod: | root@eu15 [~]# mysql -u serbianu_forum -p serbianu_forum < /home/serbianu/www/baza-foum.sql
Enter password:
ERROR 1062 (23000) at line 4489976: Duplicate entry 'd?ga' for key 1 |
Why is this happening? I can not to insert backup? 
[ Added: 28-03-2009, 14:29 ]
if someone can help me? really is urgent? thanks
[ Added: 28-03-2009, 21:06 ]
import fit to 55%
[ Added: 30-03-2009, 03:29 ]
I fix this problem. Thank you all for your help 
|
|
|
