FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » Installation Problem

Show: Today's Messages :: Polls :: Message Navigator

Installation Problem [message #17248]

Sun, 21 March 2004 13:03

apmoh

Messages: 5
Registered: March 2004

Karma: 0

Junior Member

Installed FUDforum 2.6.1 yesterday. Everything went a lot smoother than I had expected, I am very impressed. We are having one problem:

When a message or reply is posted it can only be viewed once, subsequent views cause an error like:

(/home/.../index.php) 2000: Duplicate entry '5-3' for key 2
Query:
Server Version: 3.23.54
[Referring Page] http://mam.space-available.com/index.php?t=thread&frm_id=1&rid=3&S=04d3f7363e63bc3d5295c0da912c137a&SQ=92639ec13c69b6a2391400268ce8e4fd

As you can see we are running mysql 3.23.54 and php 4.2.3.

Our host does not allow direct connections to the mysql server, only through php. We originally left the host blank, but have experimented with localhost and :tmp/mysql.sock with no change in behaviour. Everything else seems to be working, I had expected that if the host thing was going to be a problem then it would be all or nothing.

Anyway it looks like there is some problem in marking a message as read, and judging from the paucity of comments in the forum it seems particular to our setup. Any clues on where to look would be greatly appreciated.

Thanks,

Anthony

Report message to a moderator

Re: Installation Problem [message #17254 is a reply to message #17248]

Sun, 21 March 2004 18:11

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Your ISP probably has the same MySQL setting defined for everyone inside PHP.ini, which is perfectly fine.

The problem is that the error message you are showing me does not include backtrace nor the query that failed. Which means I have no idea what query had failed.

I think I found 1 possible cause (patch below), but we won't know if that was indeed until you try it. Apply the patch rebuild the theme and let me know if the problem persists.
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2548

FUDforum Core Developer

Report message to a moderator

Re: Installation Problem [message #17255 is a reply to message #17254]

Sun, 21 March 2004 22:23

apmoh

Messages: 5
Registered: March 2004

Karma: 0

Junior Member

Ok, I tried the patch (rebuilt theme) and I am getting slightly different behaviour. I'm pretty sure that we didn't see any error messages until after we created the topic and viewed it at least once (per user). Then subsequently viewing the topic would give errors. Now after applying the patch, I get the same error (2000) when I create the topic. As near as I can tell no logged in user can see the message normally. Visitors (i.e. not logged in) can see the message just fine. You can also see it by selecting <today's messages>

If you want I'll back the patch out and confirm the previous behaviour.

Thanks,

Anthony

Report message to a moderator

Re: Installation Problem [message #17256 is a reply to message #17255]

Mon, 22 March 2004 03:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Do you still not see the query that is failing?

Report message to a moderator

Re: Installation Problem [message #17259 is a reply to message #17256]

Mon, 22 March 2004 09:14

apmoh

Messages: 5
Registered: March 2004

Karma: 0

Junior Member

This is what I get when I attempt to view a message as a logged-in member:

(/home/.../index.php) 2000: Duplicate entry '1-3' for key 2
Query:
Server Version: 3.23.54
[Referring Page] http://mam.space-available.com/index.php?t=thread&frm_id=1&rid=3&S=eca16a5678a6c0d89e3a4c590461355c&SQ=48b126804ddae6d7df2542d1d5cad2ee

I did edit the page address, but other than that this is cut and paste from the actual page. My partner and I agree that the behaviour since the patch is different in that prior to the patch we got the above message when we tried to view a new post after seeing it once. Since the patch we get this message when we create a new topic. If we try to view the post after creation we get this same message if we are logged-in.

Report message to a moderator

Re: Installation Problem [message #17264 is a reply to message #17259]

Mon, 22 March 2004 14:41

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Hmm, please try applying 2 more patches, if they don't solve the problem @ least they'll give us more information to go on.

http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2549
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=2550

P.S. Error code 2000 is very strange because according to MySQL documentation such error code does not exist.

Report message to a moderator

Re: Installation Problem [message #17287 is a reply to message #17264]

Tue, 23 March 2004 00:25

apmoh

Messages: 5
Registered: March 2004

Karma: 0

Junior Member

Well, it did get us more info...

Now we get:

(/home/.../index.php) 2000: Duplicate entry '1-3' for key 2
Query: INSERT INTO fud26_forum_read (forum_id, user_id, last_view) VALUES (1, 3, 1080001365)
Server Version: 3.23.54
[Referring Page] http://mam.space-available.com/index.php?t=thread&frm_id=1&rid=3&S=eca16a5678a6c0d89e3a4c590461355c&SQ=70c380864db6f3c66da41db2328e2ff7

Thanks,

Anthony

Report message to a moderator

Re: Installation Problem [message #17303 is a reply to message #17287]

Tue, 23 March 2004 20:25

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The problem is due to your MySQL returning a bogus error code 2000 (this error code does not exist). This throws the forum in for a loop, as it expects the error code to be 1062 in this instance.

I've contacted MySQL developers who may have some information on this matter. Mean while you can modify mysql/db.inc and look for line:
if (mysql_errno(fud_sql_lnk) == 1062) {

change this line to
if (mysql_errno(fud_sql_lnk) == 1062 || ysql_errno(fud_sql_lnk) == 2000) {

Report message to a moderator

Re: Installation Problem [message #17304 is a reply to message #17303]

Tue, 23 March 2004 21:31

apmoh

Messages: 5
Registered: March 2004

Karma: 0

Junior Member

I had done some searches in the mysql forum that my web host maintains but hadn't found anything. Of course, to my chagrin I hadn't searched on the obvious, the error code 2000.

Searching on 2000 turns up a dozen or so items. Most have to do with connections to the database through telnet. Most seem to do with not having the mysql daemon connect syntax exactly right.

A couple suggested that deleting the user and then re-creating it would solve the problem. I have checked the user, and it appears to have sufficient rights (actually it has all rights), and I can log on through telnet with no problem. At least as far as being able to successfully execute a show tables command.

Anyway it seems to be working fine now.

Thanks a million,

Anthony

Report message to a moderator

Previous Topic:	upgrade problem
Next Topic:	system has ran out of disk space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 11:06:16 GMT 2024

Total time taken to generate the page: 0.02389 seconds