| IMporting datadump [message #37682] |
Fri, 15 June 2007 08:36  |
ubyfudder
Messages: 43
Registered: January 2007
Karma: 0
|
Member |
|
|
I can't import my datadump in a fresh-installed fudforum.
It end with this error
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in mysite/myforum/include/core.inc on line 188
Can you help me?
|
|
|
|
|
|
|
|
| Re: IMporting datadump [message #37731 is a reply to message #37728] |
Mon, 18 June 2007 17:27  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Can you try to edit the admimport.php script and uncomment the block that disables the authentication.
FUDforum Core Developer
|
|
|
|
| Re: IMporting datadump [message #37734 is a reply to message #37731] |
Tue, 19 June 2007 07:04 |
ubyfudder
Messages: 43
Registered: January 2007
Karma: 0
|
Member |
|
|
| Ilia wrote on Mon, 18 June 2007 13:27 |
Can you try to edit the admimport.php script and uncomment the block that disables the authentication.
|
the new SQLerror
?709 ?1182236427?(C:\Programmi\wamp\www\FUDforum\include\theme\default\db.inc:72 <br />
C:\Programmi\wamp\www\FUDforum\include\theme\default\db.inc:132<br />
C:\Programmi\wamp\www\forum\adm\admimport.php:223<br />
) 1146: Table '180607_2.fud26_users' doesn't exist<br />
Query: SELECT id FROM fud26_users WHERE login='' AND users_opt>=1048576 AND (users_opt & 1048576) > 0<br />
_POST: array (
'path' => 'C:\\Documents and Settings\\MYSELF\\Desktop\\FUDforum_18_04_2007_04_10.fud.gz',
'btn_submit' => 'Import Data',
)<br />
Server Version: 5.0.27-community-nt<br />
[Referring Page] http://localhost/forum/adm/admimport.php?S=04a6a3c9cdd7b48f8830a972cbd06a7e &SQ=f5c822171ffddf38b228b26ed015acc5<br />
?1009 ?1182236461?(C:\Programmi\wamp\www\forum\index.php:75<br />
C:\Programmi\wamp\www\forum\index.php:175<br />
C:\Programmi\wamp\www\forum\index.php:274<br />
C:\Programmi\wamp\www\forum\index.php:946<br />
C:\Programmi\wamp\www\forum\index.php:1141<br />
) 1146: Table '180607_2.fud26_ses' doesn't exist<br />
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.theme, t.pspell_lang, t.theme_opt,
u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.topics_per_page,
u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc
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='04a6a3c9cdd7b48f8830a972cbd06a7e'<br />
Server Version: 5.0.27-community-nt<br />
[Referring Page] http://localhost/<br />
|
|
|
|
|
|
| Re: IMporting datadump [message #37744 is a reply to message #37739] |
Wed, 20 June 2007 14:09 |
ubyfudder
Messages: 43
Registered: January 2007
Karma: 0
|
Member |
|
|
| Ilia wrote on Tue, 19 June 2007 18:12 |
Have you tried running the script via the command line?
|
I have to do it under windows, on my office pc. It's a test-installation that I use to test the process.
But I don't know how to run the script under windows via the command line... 
Can you help me??
(I am very late, my real forum in down from more than a week now (( )
Thanks!
[Updated on: Wed, 20 June 2007 14:09] Report message to a moderator |
|
|
|
| Re: IMporting datadump [message #37751 is a reply to message #37744] |
Wed, 20 June 2007 23:03 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Run "cmd".
The cd into the forum's admin directory and run "php admimport.php"
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]