FUDforum: FUDforum Installation Issues » Problem when creating groups

Home » FUDforum » FUDforum Installation Issues » Problem when creating groups

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

Problem when creating groups [message #16746]

Mon, 16 February 2004 19:33

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

I've created a group, assigned a 'leader' and recieved the following message:

(/var/www/html/forum_data/include/theme/default/db.inc:114
/var/www/html/forum_data/include/theme/default/db.inc:292
/var/www/html/forum_data/include/theme/default/groups.inc:71
/var/www/html/forum/adm/admgrouplead.php:57
) 1064: You have an error in your SQL syntax near ';715, 4),(12, 393215, 4)' at line 1
Query: INSERT INTO fud26_gc_1076959847 (a,b,c) VALUES (3, 380863, 4),(9, 377119, 4),(11, 79;715, 4),(12, 393215, 4)
Server Version: 3.23.58
[Referring Page] http://www.vanhooijdonk.net/forum/adm/admgrouplead.php?group_id=20&rid=2&S=ba4ababfc4eb9d7487ec81486038ed48&SQ=3650de305adaf0c0ad8c699599dfb4c7

Report message to a moderator

Re: Problem when creating groups [message #16747 is a reply to message #16746]

Mon, 16 February 2004 19:41

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

When adding users:

(/var/www/html/forum/index.php:117
/var/www/html/forum/index.php:295
/var/www/html/forum/theme/default/groupmgr.php:94
/var/www/html/forum/theme/default/groupmgr.php:325
/var/www/html/forum/index.php:1158
) 1064: You have an error in your SQL syntax near ';7297, 4),(12, 393215, 4)' at line 1
Query: INSERT INTO fud26_gc_1076960331 (a,b,c) VALUES (3, 380863, 4),(9, 377119, 4),(11, 7;7297, 4),(12, 393215, 4)
Server Version: 3.23.58
[Referring Page] http://www.vanhooijdonk.net/forum/index.php?t=groupmgr&rid=2&S=ba4ababfc4eb9d7487ec81486038ed48&SQ=3650de305adaf0c0ad8c699599dfb4c7&edit=38

Report message to a moderator

Re: Problem when creating groups [message #16748 is a reply to message #16747]

Mon, 16 February 2004 19:47

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

Consistancy check stops and gives the following error:

Rebuilding group cache
(/var/www/html/forum_data/include/theme/default/db.inc:114
/var/www/html/forum_data/include/theme/default/db.inc:292
/var/www/html/forum_data/include/theme/default/groups.inc:71
/var/www/html/forum/adm/consist.php:610
) 1064: You have an error in your SQL syntax near ';7297, 4),(12, 65536, 2147483647),(12, 65536, 0),(12, 393215, 4)' at line 1
Query: INSERT INTO fud26_gc_1076960685 (a,b,c) VALUES (1, 327683, 0),(1, 378767, 2147483647),(2, 327683, 2147483647),(2, 327683, 0),(3, 380863, 4),(3, 380863, 5),(3, 380863, 2),(3, 65536, 2147483647),(3, 65536, 0),(4, 65536, 2147483647),(4, 65536, 0),(5, 327683, 2147483647),(5, 327683, 0),(6, 327683, 2147483647),(6, 327683, 0),(7, 378767, 2147483647),(7, 327683, 0),(8, 378783, 2147483647),(8, 327683, 0),(9, 65536, 2147483647),(9, 65536, 0),(9, 377119, 6),(9, 377119, 27),(9, 377119, 26),(9, 377119, 25),(9, 377119, 24),(9, 377119, 5),(9, 377119, 4),(10, 327683, 2147483647),(10, 327683, 0),(11, 65536, 2147483647),(11, 65536, 0),(11, 7;7297, 4),(12, 65536, 2147483647),(12, 65536, 0),(12, 393215, 4)
Server Version: 3.23.58
[Referring Page] http://www.vanhooijdonk.net/forum/adm/consist.php?rid=2&S=ba4ababfc4eb9d7487ec81486038ed48&SQ=3650de305adaf0c0ad8c699599dfb4c7

Report message to a moderator

Re: Problem when creating groups [message #16765 is a reply to message #16748]

Tue, 17 February 2004 15:51

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The error seems to be the result of an invalid entry inside your group_members table. That table should have an integer as the value of the group_members_opt field, but in one case it is a string?

Remove the bogus entry from that table and things should be back to normal.

FUDforum Core Developer

Report message to a moderator

Re: Problem when creating groups [message #16788 is a reply to message #16765]

Wed, 18 February 2004 11:47

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

Hi Ilia,

I do not see a String value. I do see strange user ID numbers.

Please see below:

(When I re-installed the forum some weeks ago, i've dumped and loaded the users table (nothing else). Could this have caused some problems?)

SQL result
Host: localhost
Database : vanhooijdonk_net
Generation Time: Feb 18, 2004 at 12:38 PM
Generated by: phpMyAdmin 2.3.2
SQL-query: SELECT * FROM `fud26_group_members` LIMIT 0, 30; 

id  user_id  group_id  group_members_opt  
1 0 3 327683 
2 2147483647 3 378767 
3 2147483647 4 327683 
4 0 4 327683 
5 4 5 380863 
6 5 5 380863 
7 2 5 380863 
8 2147483647 6 65536 
9 0 6 65536 
10 2147483647 7 65536 
11 0 7 65536 
12 2147483647 8 327683 
13 0 8 327683 
14 2147483647 9 327683 
15 0 9 327683 
16 2147483647 10 378767 
17 0 10 327683 
18 2147483647 11 378783 
19 0 11 327683 
20 2147483647 12 65536 
21 0 12 65536 
22 6 12 377119 
23 27 12 377119 
24 26 12 377119 
25 25 12 377119 
26 24 12 377119 
27 5 12 377119 
28 4 12 377119 
29 2147483647 13 327683 
30 0 13 327683

Report message to a moderator

Re: Problem when creating groups [message #16792 is a reply to message #16788] Wed, 18 February 2004 14:35

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The dump you are showing me only shows 30 rows (LIMIT 30)
can you verify that the entire table does not have any invalid data?

If that does not reveal a 'weird' row try adding the following to groups.inc.t and then rebuilding your theme.


<?php
/*
This should be added inside grp_rebuild_cache() function, right below the while ($o = db_rowobj($r)) { line.
*/
foreach ($o as $k => $v) {
$o->{$k} = (int) $v;
}
?>

FUDforum Core Developer

Report message to a moderator

Re: Problem when creating groups [message #16796 is a reply to message #16792]

Wed, 18 February 2004 15:39

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

Do I have to edit a particular file or can I do this through the admin page?

As mentioned I loaded the users table from my previous forum. Could this give me problems in some way?

Report message to a moderator

Re: Problem when creating groups [message #16797 is a reply to message #16796]

Wed, 18 February 2004 15:49

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It is possible that the problem are due to incorrect data load, it is hard to day. Technically speaking the 3 columns used in the failing operation MUST be integers.

The 'fix' should be applied by manually editing the file I mentioned.

FUDforum Core Developer

Report message to a moderator

Re: Problem when creating groups [message #16803 is a reply to message #16797]

Wed, 18 February 2004 19:53

patrick

Messages: 103
Registered: September 2002

Karma: 0

Senior Member

Regarding the load, I've installed a new forum, followed by the user load.
Afterwards I created additional forums.

Could I please send you a dump of the user table (it's small) to see if you see andy errors?

Thanks, Patrick

Report message to a moderator