1.1.0 to 1.1.1

[Kathleen Chute]

Hi There, So , im on ver 1.1.0 and in trying to register someone This Am , I recived this message

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 ' '', 'skipmax', '', 1, 0, 4, '', '', '', '', '', '', '', '', '', '', '', '', '',' at line 3
File: /home/fawnfoto/public_html/gotchaserved.com/Sources/Subs-Members.php
Line: 807

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

I Have Been trying to Avoid this upgrade for a Long time,
But I Updated the 1.1.0
To 1.1.1 With No Trouble.
I Tried to Register again and still had the Still had the Same error, Did some Googling, and Found a Message that said a Large Package install would Help.
I Tried to Install and I I Just Got This Massage

The package you tried to upload either is not a valid package or has become corrupted.
The Fear I Get with This Upgrade is Become Fatal
AhGGG



Kathleen

[flapjack]

I can give you a hand if you like, just PM me

[deansmar]

i would say all you need to do is run the SQL upgrade in your database, the SMF forum side of the update seems to have gone OK, but the Database update was not performed

the forum is running OK at 1.1.10 but the database is lagging behind

[MrPhil]

You are at 1.1.10, not 1.1.0. You are confusing people trying to help you when you give the wrong version.

1.1.9, 1.1.10, and 1.1.11 all have the same database layout, so there is no requirement to upgrade the database. All you will do is eliminate the annoying "you may need to upgrade your database" message (see my sig > Fixes > "Database Upgrade Required" paragraph 3 for the procedure to update the version number, which is the only difference among them). This assumes that earlier upgrades were done completely and correctly, and that the database is truly up to date except for the version number.

If you're at SMF 1.1.10, you really should upgrade to SMF 1.1.11, as it has some important security fixes.

Can you show us the complete error message? It should contain the entire SQL query that MySQL is objecting to. That would give an idea of what the problem is. And what mods and other changes to SMF do you have installed?

[Kathleen Chute]

Sorry about The wrong version. Im not very good at this.
I Have given the entire error.
Thanks.

[MrPhil]

You're sure that's the entire error message? Normally, MySQL gives the entire SQL query (or at least, all it can fit of the query, if large), not just the "error occurred near here:" portion. Here are lines 802 through 807 in the vanilla 1.1.10:

Code Select Expand


    // Register them into the database.
    db_query("
        INSERT INTO {$db_prefix}members
            (" . implode(', ', array_keys($regOptions['register_vars'])) . ")
        VALUES (" . implode(', ', $regOptions['register_vars']) . ')', __FILE__, __LINE__);
    $memberID = db_insert_id();
Presumably there's something wrong with the format of the VALUES list, but without seeing the entire query, it's hard to tell. There might be a stray comma or one or more $regOptions elements might be lacking single quotes around the data values. Presumably the number of values match the number of field names given, which are in turn correct for the members database table, and there are no duplicate or invalid field names.

It's a bit odd that line 807 = line 3 of the query isn't the VALUES line... do you have any mods installed? Any idea why the Subs-Members.php file would be missing one line somewhere in the first 807 lines?

If worst comes to worst, and no one can find the error, try temporarily inserting the following code just before the mysql_query( line:

Code Select Expand

echo "INSERT INTO {$db_prefix}members
            (" . implode(', ', array_keys($regOptions['register_vars'])) . ")
        VALUES (" . implode(', ', $regOptions['register_vars']) . ')';
and then copy the output to here so we can see what went wrong. Just to be sure that this is the failing query, temporarily add

Code Select Expand

echo "did we just get an error?";
right before the $memberID = db_insert_id(); line. Your error message will hopefully be sandwiched between the two lines, and the dump of the query should show what went wrong. If the error message is before or after this pair, it means the error is elsewhere.

[flapjack]

this problem is caused by StopSpammer mod, and the fact that it tries to insert an additional value into db

[Kathleen Chute]

Great , Thanks You Flapjack, So I Just Disable it Right. That mod is No Good anyhow.
Please advise!!
Thanks to You all
Kathleen 

[flapjack]

I disabled it already

[Kathleen Chute]

I would Like to Know If There Is a Similar Fix from  1.1.12 to 1.1.13 .
No Matter what The admin Link Provided to me insmf is a 404 error.
I Just had my whole site Crash due to Server issues yesterday and It got me sooo Nervous. This is My Dads Site
Now SMF is warning me to Upgrade again only this time in a red warning box. This is awful,
This Last Method was Quick and SOOO Helpful, it eased My Mind,
After Yesterday and my heart stopping a bit , and whilst, My www.runwiththewild.com site is still broken and completely down,
I need to take careful Steps to prevent another heart a attack .
Thanks Kathleen

[kat]

When I go to your site, I get this:

"This file was encoded by the Zend Guard. In order to run it, please install the Zend Optimizer (available without charge), version 3.0.0 or later." and a load of associated crap.

Sounds like it's "Have a word with your host" time, to me.

[Kathleen Chute]

 Yeah, That site is a scripting nightmare , does it effect smf ?
Thanks
Kathleen

[kat]

I was wondering if it was the Zend guard thing that was the problem.

Best ask your host about that, Kaff, if you didn't put the file that requires it on your site.

Is that where your forum should be?

Or, is it in a subdirectory?

[Kathleen Chute]

My Forum is www.gotchaserved.com . The Forum was Down, But we got it back up. What I need it The  link to Upgrade the 1.1.12.to 1.1.13.
The link just simply has never worked ever, They Just Upgraded to a Pph version that does not support zend, So my runwiththewild is a Mess but The 404 error I get to Upgrade is what Im Needed . I want to make sure everything is ok, Ive had enough trouble for a Few days
Thanks
Kathleen

[kat]

My forum's the same.

What I do, is get this:

http://custom.simplemachines.org/mods/downloads/smf_patch_1.0.21_1.1.13.tar.gz

Upload it to your Packages directory.

Once it's uploaded, go to Package manager and apply it.

Sorted (With any luck).