|
|
|
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo
|
|
|
|
[Other] SQL Error : 1146 Table 'xxx.SESSIONS_TABLE' doesn't |
| Autor |
Wiadomość |
evilmc
Posty: 289
|
 Wysłany: 21-03-2009, 20:41 [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 |
| Ostatnio zmieniony przez Matteo 01-09-2010, 15:58, w całości zmieniany 1 raz |
|
 |
|
 |
Gadatliwa Kasia 
|
|
|
|
|
lui754
Pomógł: 591 razy
Posty: 2699
|
| Wysłany: 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)
); |
|
_________________
lui754 |
|
 |
|
|
evilmc
Posty: 289
|
| Wysłany: 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 |
|
_________________
Looptroop - Bandit Queen |
|
|
|
|
|
lui754
Pomógł: 591 razy
Posty: 2699
|
| Wysłany: 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)
); |
|
_________________
lui754 |
|
|
|
|
|
evilmc
Posty: 289
|
| Wysłany: 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
Pomógł: 591 razy
Posty: 2699
|
| Wysłany: 21-03-2009, 21:06
|
|
|
| Kod: | | REPAIR TABLE phpbb_sessions; |
and
| Kod: | | REPAIR TABLE 'phpbb_users'; |
|
_________________
lui754 |
|
|
|
|
|
evilmc
Posty: 289
|
| Wysłany: 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
Pomógł: 591 razy
Posty: 2699
|
| Wysłany: 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 |
_________________
lui754 |
|
|
|
|
|
MagicalFire
Pomógł: 980 razy
Posty: 4353
|
| Wysłany: 21-03-2009, 21:35
|
|
|
| lui754 napisał/a: | | Brak table phpbb_users. Wgraj backup sql. |
None phpbb_users table. Upload backup sql. |
_________________
nie za takie Przemo walczyliśmy |
|
|
|
|
|
evilmc
Posty: 289
|
| Wysłany: 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
Pomógł: 980 razy
Posty: 4353
|
| Wysłany: 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 |
_________________
nie za takie Przemo walczyliśmy |
|
|
|
|
|
Seraphe
Pomógł: 38 razy
Posty: 606
|
| Wysłany: 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. |
_________________
"Dostałem warna i teraz obniżone zachowanie będę miał na semestr" |
|
|
|
|
|
Gadatliwa Kasia
|
|
|
|
|
evilmc
Posty: 289
|
| Wysłany: 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  |
|
|
|
|
|
|
|
Nie możesz pisać nowych tematów
Nie możesz odpowiadać w tematach
Nie możesz zmieniać swoich postów
Nie możesz usuwać swoich postów
Nie możesz głosować w ankietach
Możesz załączać pliki na tym forum
Możesz ściągać załączniki na tym forum
|
Dodaj temat do Ulubionych
Wersja do druku
|
Kopiowanie wszelkich treści zawartych na forum, modyfikacji oraz instrukcji bez zgody administracji i autorów tematów/postów zabronione!
Powered by phpBB modified by Przemo © 2003 phpBB
| | Strona wygenerowana w 0,07 sekundy. Zapytań do SQL: 12 |
|
 |
|
FAQ - PIERWSZA POMOC!!
REGULAMIN
SZUKAJ
Użytkownicy
Grupy
Statystyki
Rejestracja
Zaloguj
Download
Katalog Forów
