Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: carlostefano - elokuu 31, 2006, 09:16:43 IP

Otsikko: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - elokuu 31, 2006, 09:16:43 IP
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 4)' at line 3
File: /home/mhd-01/www.aumentostatura.it/htdocs/Sources/MessageIndex.php
Line: 102
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 09:08:13 AP
I have done upgrade, but when I click on a board this error appear. None knows how can I solve this problem???
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: J. Williams - syyskuu 01, 2006, 09:30:42 AP
Have you tried re-uploading it and posting us lines 100 to 102 :D
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: mimbo - syyskuu 01, 2006, 09:43:27 AP
you can upgrade from 1.08 to 1.1???  How do you do this?  Do I need to change any server settings with my hosting?

Lunarpages is my host server.
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: vbgamer45 - syyskuu 01, 2006, 09:46:01 AP
I would try to reupload MessageIndex.php in the sources file with a copy from 1.1RC3
Does it happen on all boards in your forum? or just certain ones.
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 03:24:40 IP
I have upload that file again, but nothing was changed  :( this happen with all my boards; all them are empty.
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: J. Williams - syyskuu 01, 2006, 03:26:16 IP
Can you provide us lines 100-104 of the MessageIndex.php please?
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 03:31:20 IP

Lines from 99 to 110:       

db_query("
         REPLACE INTO {$db_prefix}log_boards
            (ID_MSG, ID_MEMBER, ID_BOARD)
         VALUES ($modSettings[maxMsgID], $ID_MEMBER, $board)", __FILE__, __LINE__);
      if (!empty($board_info['parent_boards']))
      {
         db_query("
            UPDATE {$db_prefix}log_boards
            SET ID_MSG = $modSettings[maxMsgID]
            WHERE ID_MEMBER = $ID_MEMBER
               AND ID_BOARD IN (" . implode(',', array_keys($board_info['parent_boards'])) . ")
            LIMIT " . count($board_info['parent_boards']), __FILE__, __LINE__);



p.s.

when I click on a bord, the wearing change of value.
es.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 6)' at line 3
File: /home/mhd-01/www.aumentostatura.it/htdocs/Sources/MessageIndex.php
Line: 102


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 11)' at line 3
File: /home/mhd-01/www.aumentostatura.it/htdocs/Sources/MessageIndex.php
Line: 102


Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: vbgamer45 - syyskuu 01, 2006, 03:34:57 IP
That seems like a valid query what MySQL version are you running?
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 03:47:21 IP
Client API version  4.1.11 
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 03:54:42 IP
In phpmyadmin there is written 5.1 Debian and others...
Otsikko: Re: upgrade from 1.08 to 1.1
Kirjoitti: carlostefano - syyskuu 01, 2006, 07:04:51 IP
Ok, I have understood it's better if I upload 1.1 and overwrite all  :'(