| Serious upgrade problem: SQL syntax error [message #164211] |
Mon, 10 January 2011 14:42  |
 |
dario
Messages: 2
Registered: January 2011
Karma: 0
|
Junior Member |
|
|
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
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]