Another problem with upgrade... help is appreciated! :-)

[jestbiteme]

Hi! I finally solved my problem with "lots network connection" during execution of the upgrrade script. Turns out that the only thing that worked was uploading the 1.0.5 sources to overwrite the 1.1 RC1 files, and then upload the 1.1 RC 1 files again. Now it seems to work smoothly, except. . .

I get the following error:
Converting members and personal messages... Unsuccessful!
This query:
SELECT ID_MEMBER, im_ignore_list, gender, secretAnswer
FROM yabbse_members
LIMIT 0, 500;
Caused the error:
Unknown column 'im_ignore_list' in 'field list'


How can I fix this one? Any ideas? Thanks!

[Elmacik]

i think your installed mods are causing this error..

[jestbiteme]

i think your installed mods are causing this error..

Hey again! You must be getting tired of me.

I thought about that, and checked, and nothing shows as installed. Maybe something didn't uninstall cleanly, I dunno; anyway to get around it?

[Elmacik]

i think you had ignore mod. but its not completely removed.
in this case, i dont know what to do..

Hey again! You must be getting tired of me.

no not, we are friends here
(and i am not a support specialist here, just a member like you )

[xenovanis]

Are you sure all 1.1 files were uploaded properly and actually did overwrite the 'old' files?

[Oldiesmann]

Make sure that the upgrade.php you're running is the one that came with the 1.1 package and not the one that came with the 1.0.5 package...

[lomang]

having the same problem

[lomang]

can anyone help with this?

[Compuart]

jestbiteme, the upgrade.php you're using appears to be the upgrade that came with SMF 1.0.x. Reupload upgrade.php and upgrade_1-1.sql and run it.

[lomang]

i tried that and it didnt work

[Oldiesmann]

Delete upgrad.php from your site and re-upload it. Sometimes FTP clients don't overwrite files.

[dangerine]

I'm having the exact same problem while upgrading from 1.0.4 to 1.0.5.

Now I've got the added bonus of the forum refusing to come out of maintainence mode (I, the admin, can't get in. Fab.)

I get:

Converting members and personal messages... Unsuccessful!
This query:
SELECT ID_MEMBER, im_ignore_list, gender, secretAnswer
FROM yabbse_members
LIMIT 0, 500;
Caused the error:
Unknown column 'im_ignore_list' in 'field list'


When I hit Try Again, nothing happens. Don't know what to try next. HEEEELP!

[Oldiesmann]

If you're going from 1.0.4 to 1.0.5, you can just use the "update" package, and you should also be able to upgrade through the package manager (you'll see something about a patch and click here to download it). As far as getting out of maintenance mode, edit Settings.php and set $maintenance to either 1 or 0.

[dangerine]

If you're going from 1.0.4 to 1.0.5, you can just use the "update" package, and you should also be able to upgrade through the package manager (you'll see something about a patch and click here to download it). As far as getting out of maintenance mode, edit Settings.php and set $maintenance to either 1 or 0.

Thanks for replying so fast. I tried updating with package manager and got error messages about something not being set right in package manager, so I tried installing by hand (FTPing upgrade files). And that's when things hit the fan.

Oh, and now when I try to set it to go out of maintanence mode, I get:

Code Select Expand


Notice: Only variables should be assigned by reference in /home/notwitho/public_html/forum/Sources/Subs.php on line 232

Notice: Undefined index: is_admin in /home/notwitho/public_html/forum/Sources/Security.php on line 556

Notice: Undefined index: permissions in /home/notwitho/public_html/forum/Sources/Security.php on line 563

Warning: in_array(): Wrong datatype for second argument in /home/notwitho/public_html/forum/Sources/Security.php on line 563
session_start(): Cannot send session cache limiter - headers already sent (output started at /home/notwitho/public_html/forum/Sources/Subs.php:232)
Notice: Only variables should be assigned by reference in /home/notwitho/public_html/forum/Sources/Subs.php on line 232

Notice: Only variables should be assigned by reference in /home/notwitho/public_html/forum/Sources/Subs.php

I replaced all these files with the 1.0.4 versions when the update.php wouldn't work. Now what?

[xenovanis]

Apply the PHP 4.4.0 Compatibility patch and you should be fine.

[dangerine]

The hits just keep on coming. Now it's

Code Select Expand

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

At least that's less scary than half a dozen parse errors, but it's another dead end. Ideas?

Thanks for the PHP 4.4.0 tip btw.

[xenovanis]

Check the file Settings.php (open it with a texteditor or htmleditor) and see if the username and password for the database user and databasename are correct.

[dangerine]

D'oh! You're right, I'd replaced my Settings.php with a blank one.

Board's back up and I'm right back where I started. I try to read my personal messages and get:

Code Select Expand

Table '{myDB}.yabbse_im_recipients' doesn't exist
File: /home/mysite/public_html/forum/Sources/InstantMessage.php
Line: 833

Note: It appears that your database may require an upgrade. Your forum files are currently at version SMF 1.0.4, whereas your database is at version SMF 1.1 RC1. It is recommended that you execute the latest version of upgrade.php.

I go to Package Manager, click on the link to the update and get

Code Select Expand

Fatal error: Call to undefined function: getpackageinfo() in /home/mysite/public_html/forum/Sources/PackageGet.php on line 526

After that last attempt, I'm good and terrified about trying this again. On the other hand, users and yelling. OK, so, is there some step I might have missed last time?

Thanks a ton!