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

Home » FUDforum » FUDforum Installation Issues » Serious upgrade problem: SQL syntax error (3.0.0 -> 3.0.2)
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
Serious upgrade problem: SQL syntax error [message #164211] Mon, 10 January 2011 09:42 Go to next message
dario is currently offline  dario
Messages: 2
Registered: January 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi all, today I tried to upgrade my postgres based FUD from 3.0.0 to 3.0.2 but I obtained the following error:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "LIMIT" LINE 1: ...d30_bookmarks WHERE user_id='4' AND thread_id='1044' LIMIT 1 ^ in /mnt/replicated/var/www/fud/forum/sql/pgsql/db.inc on line 93

Fatal error: Uncaught exception 'Exception' with message ': ERROR: syntax error at or near "LIMIT" LINE 1: ...d30_bookmarks WHERE user_id='4' AND thread_id='1044' LIMIT 1 ^ @ DELETE FROM fud30_bookmarks WHERE user_id='4' AND thread_id='1044' LIMIT 1' in /mnt/replicated/var/www/fud/upgrade.php:99 Stack trace: #0 /mnt/replicated/var/www/fud/forum/sql/pgsql/db.inc(93): fud_sql_error_handler('DELETE FROM fud...', 'ERROR: syntax ...', '', 'PostgreSQL 8.3....') #1 /mnt/replicated/var/www/fud/forum/include/dbadmin.inc(399): q('DELETE FROM fud...') #2 /mnt/replicated/var/www/fud/forum/include/dbadmin.inc(246): delete_duplicate_values('fud30_bookmarks', 'user_id,thread_...') #3 /mnt/replicated/var/www/fud/upgrade.php(911): create_primary_key('fud30_bookmarks', 'user_id,thread_...') #4 {main} thrown in /mnt/replicated/var/www/fud/upgrade.php on line 99


I've always used postgres with no modification on database. I have messages stored in the database.

I've already reverted my backup to 3.0.0 but I still would like to upgrade it to 3.0.2. What can I do?


Dario
Re: Serious upgrade problem: SQL syntax error [message #164214 is a reply to message #164211] Tue, 11 January 2011 11:01 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3680
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Yip, that is a bug.
As workaround, manually remove duplicates from fud30_bookmarks and rerun the upgrade script.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: charset problems
Next Topic: Here an atch there an atch, every where an atch atch
Goto Forum:
  

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

Current Time: Sun Sep 23 06:53:40 EDT 2018

Total time taken to generate the page: 0.00571 seconds