| DESPERATE [message #26852] |
Wed, 17 August 2005 16:24  |
jkliment
Messages: 10
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
Hi guys!
I am really desperate.
I am using fud forum version 2-6-15, and had quite a bit of messages in there, from a course I was giving. At one point, it starting givin a sql error when people tried to log in.
I made a backup using the admin, and proceeded to reinstall the forum (I am using postgresql).
After reinstalling everything, I tried to import the data from the .fud file, and it again gave me an error.
Can someone help?
If I cant recover the messages, I cant give the students their grades!!!
|
|
|
|
| Re: DESPERATE [message #26853 is a reply to message #26852] |
Wed, 17 August 2005 16:34  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The SQL error messages are stored inside sql_errors file in the errors/ directory. Send me last few lines from that file and I can tell you what the error is.
FUDforum Core Developer
|
|
|
|
| Re: DESPERATE [message #26854 is a reply to message #26853] |
Wed, 17 August 2005 16:36 |
jkliment
Messages: 10
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
Thank you!
Thank you!
Thank you!
I just reinstalled the forum successfully.
Went in the import data feature as admin.
Selected de data file.
Here is the outpup:
Warning: pg_query(): Query failed: ERROR: Bad int8 external representation "" in /var/www/FUDforum/include/theme/default/db.inc on line 148
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/FUDforum/include/theme/default/db.inc on line 88
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/FUDforum/include/theme/default/db.inc on line 88
(/var/www/FUDforum/include/theme/default/db.inc:148
/var/www/html/ibm/forum/adm/admimport.php:187
) : ERROR: Bad int8 external representation ""
Query: INSERT INTO fud26_users VALUES ('1','Anonymous Coward','Anonymous Coward','1','Anonymous Coward','dev@null' ,'','','','0','','','','','','','','0','America/Montreal','0','0','0','','1 ','0','0','0','0','','','0','0','0','','','','','','','','6585269','','0',' 0')
_POST: S=ccc73f9713c7e30903aadabc1e28ff4b&SQ=e3dbaf32490449abb40da099446be067& amp;path=/var/www/html/ibm/FUD.fud&btn_submit=Import Data&
Server Version:
[Referring Page] http://200.155.18.43:8080/ibm/forum/adm/admimport.php?S=ccc73f9713c7e30903a adabc1e28ff4b&SQ=e3dbaf32490449abb40da099446be067
|
|
|
|
|
|
| Re: DESPERATE [message #26856 is a reply to message #26852] |
Wed, 17 August 2005 18:02 |
jkliment
Messages: 10
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
I may be way off here, but it seems that the syntax for inserting the user is wrong, since the error shown doing the import procedure says:
: ERROR: Bad int8 external representation ""
Query: INSERT INTO fud26_users VALUES ('7','analucia','analucia','dd263e0119f75a174139d24d6810dadd','Ana Luiza Rocha','teste1(at)teste(dot)com' ,'','','','0','','','','','','','','0','America/Montreal','0','1123294726', '0','','1','0','0','0','1123294726','','','0','0','0','','','','','','','', '4357111','','0','0')
It was giving this error when it tried to insert the anonymous user, so I removed that line from the .fud file, and after that the error happened on the next insert line (which is the one above).
Could that be it?
|
|
|
|
| Re: DESPERATE [message #26857 is a reply to message #26852] |
Wed, 17 August 2005 19:25 |
jkliment
Messages: 10
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
I believe I found the problem, or part of it.
When FUDForum created the .fud file that is used for backup, it fails to place a value (any value) in the field that correspond to ICQ in the users database. This field is set as a BIGINT, and (using postgresql, at least) it requires a value, ANY value to be inserted on the field.
I edited the .fud file, and after that was able to import the file, recovering all my users and topics.
I am no postgresql expert, and don't know the first thing about php, but logic and common sense helped me here.
How I found out?
Well, I installed phpPgAdmin, tried to insert a line in the users table, and saw the error...
UNFORTUNATELY, there is another error.
After it finished processing, it gave me the following error:
Processed 10000 queries
Warning: pg_query(): Query failed: ERROR: Cannot create unique index. Table contains non-unique values in /var/www/FUDforum/include/theme/default/db.inc on line 148
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/FUDforum/include/theme/default/db.inc on line 88
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/FUDforum/include/theme/default/db.inc on line 88
(/var/www/FUDforum/include/theme/default/db.inc:148
/var/www/html/ibm/forum/adm/admimport.php:211
) : ERROR: Cannot create unique index. Table contains non-unique values
Query: CREATE UNIQUE INDEX fud26_users_i_e ON fud26_users (email)
My main topics are back, it says that it has a few hundred messages there, but I see no messages on the topics.
If I try to post a new message it gives me this error:
Warning: pg_query(): Query failed: ERROR: parser: parse error at or near ")" at character 40 in /var/www/html/ibm/forum/index.php on line 150
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/ibm/forum/index.php on line 90
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/html/ibm/forum/index.php on line 90
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /var/www/html/ibm/forum/index.php on line 56
So, I am still desperate 
|
|
|
|
| Re: DESPERATE [message #26858 is a reply to message #26857] |
Thu, 18 August 2005 00:40 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Problem was resolved.
FUDforum Core Developer
|
|
|
|
|
|
| Re: DESPERATE [message #26860 is a reply to message #26852] |
Thu, 18 August 2005 03:12 |
jkliment
Messages: 10
Registered: August 2005
Karma: 0
|
Junior Member |
|
|
Well,
we celebrated too early..
When I try to insert a new message, I get this:
Warning: pg_query(): Query failed: ERROR: Cannot insert a duplicate key into unique index fud26_msg_pkey in /var/www/html/ibm/forum/index.php on line 150
Warning: pg_query(): supplied argument is not a valid PostgreSQL link resource in /var/www/html/ibm/forum/index.php on line 90
Warning: pg_fetch_row(): supplied argument is not a valid PostgreSQL result resource in /var/www/html/ibm/forum/index.php on line 90
(/var/www/html/ibm/forum/index.php:150
/var/www/html/ibm/forum/index.php:248
/var/www/html/ibm/forum/theme/default/post.php:1394
/var/www/html/ibm/forum/theme/default/post.php:3762
/var/www/html/ibm/forum/index.php:1241
) : ERROR: Cannot insert a duplicate key into unique index fud26_msg_pkey
Query: INSERT INTO fud26_msg ( thread_id, poster_id, reply_to, ip_addr, host_name, post_stamp, subject, attach_cnt, poll_id, icon, msg_opt, file_id, foff, length, file_id_preview, offset_preview, length_preview, mlist_msg_id, poll_cache ) VALUES( 0, 2, 0, '200.244.149.220', NULL, 1124377670, 'testete', 0, 0, '', 1, 30000, 0, 5, 0, 0, 0, NULL, '' )
_GET: t=post&
_POST: msg_subject=testete&thr_ordertype=0&thr_orderexpiry=1000000000& msg_icon=&fnt_size=&fnt_color=&fnt_face=&msg_body=teste& ;tmp_f_val=1&msg_poster_notif=Y&msg_show_sig=Y&S=d29b9867a41046 3ecb3cea9104de81ce&SQ=2236503220ea0b53de8d156779d010a6&submitted=1& amp;reply_to=0&th_id=&frm_id=3&start=0&msg_id=0&pl_id=0 &old_subject=&prev_loaded=1&btn_submit=1&
Server Version:
[Referring Page] http://200.155.18.43:8080/ibm/forum/index.php?t=post&frm_id=3&S=d29 b9867a410463ecb3cea9104de81ce&SQ=2236503220ea0b53de8d156779d010a6&
|
|
|
|
| Re: DESPERATE [message #26861 is a reply to message #26860] |
Thu, 18 August 2005 03:30 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
this is easy to fix, run the following:
value = SELECT max(id) FROM fud26_msg;
SELECT setval('fud26_msg_id_seq', value);
FUDforum Core Developer
|
|
|
|
|
|
| Re: DESPERATE [message #26869 is a reply to message #26866] |
Thu, 18 August 2005 13:01 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Yeah, just run this command in PostgreSQL.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]