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

Home » FUDforum Development » Bug Reports » Strange SQL error on consistency check
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Strange SQL error on consistency check [message #17730] Wed, 14 April 2004 16:06 Go to next message
christo is currently offline  christo   Germany
Messages: 25
Registered: February 2004
Karma: 0
Junior Member
When I run the consistency checker I get the following reproducible error:

Quote:


Rebuilding group cache
(/var/www/FUDforum2/adm/consist.php) 1064: You have an error in your SQL syntax near ';668?, 7),(17, 320605, 2147483647),(17, 377615, 4),(17, 377615, 51),(17, 393215,' at line 1
Query: INSERT INTO ff_gc_1081958376 (a,b,c) VALUES (1, 327681, 0),(1, 378621, 2147483647),(2, 327683, 0),(2, 378767, 2147483647),(2, 196608, 8),(11, 196608, 8),(11, 327683, 0),(11, 378767, 2147483647),(3, 327683, 0),(3, 378767, 2147483647),(4, 327683, 0),(4, 378767, 2147483647),(5, 327683, 0),(5, 378767, 2147483647),(6, 327683, 0),(6, 378767, 2147483647),(7, 327683, 0),(7, 378767, 2147483647),(8, 327683, 0),(8, 327711, 53),(8, 378755, 2147483647),(10, 327683, 0),(10, 378767, 2147483647),(12, 327683, 0),(12, 370741, 2147483647),(12, 524287, 4),(12, 377759, 21),(12, 377759, 22),(12, 377759, 23),(12, 377759, 24),(12, 377759, 26),(12, 377759, 27),(12, 377759, 35),(12, 377759, 36),(12, 377759, 37),(12, 377759, 38),(12, 377759, 39),(12, 377759, 41),(12, 377759, 42),(12, 377759, 43),(12, 377759, 44),(12, 377759, 45),(12, 377759, 46),(12, 377759, 47),(12, 377759, 48),(12, 377759, 52),(12, 377759, 57),(12, 377759, 58),(12, 377759, 61),(12, 377759, 68),(12, 377759, 73),(12, 377759, 82),(12, 377759, 83),(12, 377759, 84),(12, 377759, 86),(12, 377759, 87),(12, 377759, 88),(12, 377759, 89),(12, 377759, 92),(12, 377759, 93),(12, 377759, 94),(12, 377759, 95),(12, 377759, 96),(12, 377759, 97),(18, 327683, 0),(18, 524287, 4),(18, 377759, 21),(18, 377759, 22),(18, 377759, 23),(18, 377759, 24),(18, 377759, 26),(18, 377759, 27),(18, 377759, 35),(18, 377759, 36),(18, 377759, 37),(18, 377759, 38),(18, 377759, 39),(18, 377759, 41),(18, 377759, 42),(18, 377759, 43),(18, 377759, 44),(18, 377759, 45),(18, 377759, 46),(18, 377759, 47),(18, 377759, 48),(18, 377759, 52),(18, 377759, 57),(18, 377759, 58),(18, 377759, 61),(18, 377759, 68),(18, 377759, 73),(18, 377759, 82),(18, 377759, 83),(18, 377759, 84),(18, 377759, 86),(18, 377759, 87),(18, 377759, 88),(18, 377759, 89),(18, 377759, 92),(18, 377759, 93),(18, 377759, 94),(18, 377759, 95),(18, 377759, 96),(18, 377759, 97),(18, 370741, 2147483647),(31, 327683, 0),(31, 524287, 4),(31, 377759, 21),(31, 377759, 22),(31, 377759, 23),(31, 377759, 24),(31, 377759, 26),(31, 377759, 27),(31, 377759, 35),(31, 377759, 36),(31, 377759, 37),(31, 377759, 38),(31, 377759, 39),(31, 377759, 41),(31, 377759, 42),(31, 377759, 43),(31, 377759, 44),(31, 377759, 45),(31, 377759, 46),(31, 377759, 47),(31, 377759, 48),(31, 377759, 52),(31, 377759, 57),(31, 377759, 58),(31, 377759, 61),(31, 377759, 68),(31, 377759, 73),(31, 377759, 82),(31, 377759, 83),(31, 377759, 84),(31, 377759, 86),(31, 377759, 87),(31, 377759, 88),(31, 377759, 89),(31, 377759, 92),(31, 377759, 93),(31, 377759, 94),(31, 377759, 95),(31, 377759, 96),(31, 377759, 97),(31, 370741, 2147483647),(32, 327683, 0),(32, 524287, 4),(32, 377759, 21),(32, 377759, 22),(32, 377759, 23),(32, 377759, 24),(32, 377759, 26),(32, 377759, 27),(32, 377759, 35),(32, 377759, 36),(32, 377759, 37),(32, 377759, 38),(32, 377759, 39),(32, 377759, 41),(32, 377759, 42),(32, 377759, 43),(32, 377759, 44),(32, 377759, 45),(32, 377759, 46),(32, 377759, 47),(32, 377759, 48),(32, 377759, 52),(32, 377759, 57),(32, 377759, 58),(32, 377759, 61),(32, 377759, 68),(32, 377759, 73),(32, 377759, 82),(32, 377759, 83),(32, 377759, 84),(32, 377759, 86),(32, 377759, 87),(32, 377759, 88),(32, 377759, 89),(32, 377759, 92),(32, 377759, 93),(32, 377759, 94),(32, 377759, 95),(32, 377759, 96),(32, 377759, 97),(32, 370741, 2147483647),(13, 327683, 0),(13, 378767, 2147483647),(14, 327683, 0),(14, 378767, 2147483647),(15, 344071, 0),(15, 393215, 2147483647),(16, 327683, 0),(16, 327601, 4),(16, 57<7=7, 7),(16, 320605, 2147483647),(16, 377615, 51),(16, 393215, 54),(16, 377615, 55),(16, 377615, 59),(16, 377615, 70),(16, 377615, 74),(16, 377615, 75),(16, 377615, 76),(16, 377615, 77),(16, 377615, 78),(16, 377615, 79),(16, 377615, 85),(16, 377615, 87),(17, 327681, 0),(17, 5;668?, 7),(17, 320605, 2147483647),(17, 377615, 4),(17, 377615, 51),(17, 393215, 54),(17, 377615, 55),(17, 377615, 59),(17, 377615, 70),(17, 377615, 74),(17, 377615, 75),(17, 377615, 76),(17, 377615, 77),(17, 377615, 78),(17, 377615, 79),(17, 377615, 85),(17, 377615, 87),(19, 327683, 0),(19, 378767, 2147483647),(20, 327683, 0),(20, 378767, 2147483647),(21, 327683, 0),(21, 378767, 2147483647),(24, 327683, 0),(24, 378767, 2147483647),(25, 327683, 0),(25, 370743, 2147483647),(25, 524287, 4),(25, 377759, 94),(25, 377759, 95),(25, 377759, 96),(25, 377759, 97),(26, 327683, 0),(26, 370743, 2147483647),(26, 524287, 4),(26, 377759, 94),(26, 377759, 95),(26, 377759, 96),(26, 377759, 97),(27, 327683, 0),(27, 196608, 4),(27, 378767, 2147483647),(28, 327683, 0),(28, 370743, 2147483647),(28, 524287, 4),(28, 377759, 94),(28, 377759, 95),(28, 377759, 96),(28, 377759, 97),(29, 327683, 0),(29, 370743, 2147483647),(29, 524287, 4),(29, 377759, 94),(29, 377759, 95),(29, 377759, 96),(29, 377759, 97),(30, 327683, 0),(30, 370743, 2147483647),(30, 524287, 4),(30, 377759, 94),(30, 377759, 95),(30, 377759, 96),(30, 377759, 97)
Server Version: 3.23.49-log
[Referring Page] http://forum.gsi.de/adm/consist.php?rid=3&S=5d9845221c49b5fea1700bf953e 063b5&SQ=e1281c5d37c92ed5ad671e829d3599f8





Christopher Huhn, GSI Darmstadt, Germany
Re: Strange SQL error on consistency check [message #17731 is a reply to message #17730] Wed, 14 April 2004 16:43 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is fixed in later releases, upgrading to 2.6.1 or 2.6.2 will fix the problem.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Image view premission error
Next Topic: IP address.
Goto Forum:
  

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

Current Time: Fri Sep 27 23:13:03 GMT 2024

Total time taken to generate the page: 0.02921 seconds