FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » DESPERATE
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
DESPERATE [message #26852] Wed, 17 August 2005 12:24 Go to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 12:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 12:36 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 #26855 is a reply to message #26854] Wed, 17 August 2005 12:38 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
And when I try to open the forum page now I get this:

Warning: pg_query(): Query failed: ERROR: parser: parse error at end of input 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
Re: DESPERATE [message #26856 is a reply to message #26852] Wed, 17 August 2005 14:02 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 15:25 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 Sad
Re: DESPERATE [message #26858 is a reply to message #26857] Wed, 17 August 2005 20:40 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Problem was resolved.

FUDforum Core Developer
Re: DESPERATE [message #26859 is a reply to message #26858] Wed, 17 August 2005 21:15 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
All my thanks to Ilia for his help!
Re: DESPERATE [message #26860 is a reply to message #26852] Wed, 17 August 2005 23:12 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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] Wed, 17 August 2005 23:30 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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 #26866 is a reply to message #26861] Thu, 18 August 2005 03:03 Go to previous messageGo to next message
jkliment is currently offline  jkliment   Brazil
Messages: 10
Registered: August 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
sorry, but, how do I run this?
Is this a statement to be run in phpPgAdmin?

[Updated on: Thu, 18 August 2005 03:06]

Report message to a moderator

Re: DESPERATE [message #26869 is a reply to message #26866] Thu, 18 August 2005 09:01 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Yeah, just run this command in PostgreSQL.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Japanese theme not working
Next Topic: Installation breaks after first screen
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 22 19:02:36 EDT 2017

Total time taken to generate the page: 0.00533 seconds