Whenever I try to upgrade from 1.1.4 to 2.0 I get this error:
Fatal error: Call to undefined function: mysql_real_escape_string() in /v2/forums/Sources/Subs-Db-mysql.php on line 145
How are you installing the upgrade? Are you downloading the large upgrade package and overwriting all your files on the server?
Yes, I downloaded the Large Upgrade Package and overwrote all the files on the server with the package files.
I'm not 100% sure, but that function is part of CORE PHP functionality. What version of php are you running?
Last time I checked, it was PHP 2.4.0
Quote from: lordtron on August 11, 2008, 12:01:51 PM
Last time I checked, it was PHP 2.4.0
huh! I think you might want to check again. But if that is true ... as we're up to PHP 5 now ... and PHP 4.4.9 is the latest stable version ... PHP 2 is OLD.=, I don't know how SMF is working at all on that.
http://www.php.net/mysql_real_escape_string - (PHP 4 >= 4.3.0, PHP 5, PECL mysql:1.0)
Alright, my phpMySQL is 2.4.0
My PHP is 4.2.2
Well that is your problem as well then PHP 4 >= 4.3.0. I'm sure 4.2.2 is quite old as well, you need to be greater than or equal to 4.3.0. So an upgrade of your PHP is in order.
Well that is out of the question then.
I guess I am gonna need to use my own server or get a new hosting plan if I want to move to 2.0 for this website.
Well I would look to a better host that is willing to use up-to-date (and most likely) more secure software.
Not sure even after the conversion process there aren't any >= 4.2.2 functions needed, so I'm not sure it will run after the upgrade on another system and moved back.
lol
I have the funniest thing to say. This topic post was about my new hosting. It has the most up-to-date version of PHP and MySQL and that is how I am getting this error.
Any answers about that?
PHP: 5.2.6
MySQL: 5.0.51B(I do have access to 6.0.4 Alpha)
You getting the exact same error? When you are trying to upgrade your 1.1.4 SMF forum to 2.0 BETA Public 3.1 on that host?
... and this isn't the computer that's sitting next to you?
I get a different error all together when I upgrade on my old hosting.
But I am talking about my own server that I have when I try to upgrade from 1.1.4 SMF forum to 2.0 Beta Public 3.1. The one that is the computer next to me.
You started this thread, you got an error. I asked what PHP version you're running to get this error and you said 4.2.2. Now you say you're on PHP: 5.2.6. So what error are you getting now?!!
This error message came from the PHP 5.2.6 server.
So when I first asked why did you answer this?
Quote from: lordtron on August 11, 2008, 06:30:07 PM
Alright, my phpMySQL is 2.4.0
My PHP is 4.2.2
Are you sure you're working on the same server, can you try it again!
Now it won't even tell me what the error is. It just says Error when I am on Step 4: Database Changes
Executing upgrade script 1 of 2.
Executing: "Updating and creating indexes..." (1 of 19 - of this script).
Try this search and see if any of those thread offer any assistance Executing: Updating and creating indexes... (http://www.simplemachines.org/community/index.php?action=search2;params=YWR2YW5jZWR8J3wxfCJ8YnJkfCd8MjMsNDUsMTI1LDgwLDQ4LDEyNCw0Nyw4Nyw4OCw5Miw5MywxMTcsMTYyLDI2LDc1LDEzMCwzMSw0NCw3NCwxMDMsMTIzLDEsMTI2LDE5LDMwLDI0LDM2LDI5LDE0NSwxNDEsMTQ2LDEwLDIwLDEzMiwxMzMsMTM0LDEzNSw5LDExLDE0NywxNDgsODYsMTY3LDE2OCwyLDEzNywzNywzLDM4LDYwLDMzLDc3LDEzOCw1OSw3OSwzNCw5NiwxMDYsNzIsMTE1LDUsNDAsNTYsMTE2LDQsMTU1LDE1NiwxNTksMTU3LDE1OCw2LDgsNDEsMzUsNTAsNTEsMTI4LDEyOXwifHNob3dfY29tcGxldGV8J3x8InxzdWJqZWN0X29ubHl8J3x8Inxzb3J0X2RpcnwnfGRlc2N8Inxzb3J0fCd8cmVsZXZhbmNlfCJ8c2VhcmNofCd8RXhlY3V0aW5nOiBVcGRhdGluZyBhbmQgY3JlYXRpbmcgaW5kZXhlcy4uLg==)
Just found a million other issues, well not a million, but a ton of other issues. Someone else had my issue, but was using 1.1.5 and never got an answer for it.
Well look at more than one, and try to look at the 'solved' ones then.. I sure I saw at least 3 on the first page of that search. You might have to look past the very first one you look at ...
Alright, I believe I figured it out.
I think it was because some of my Theme files where still pulling from my other host. Plus my Forum files where for 1.1.4 and my database was running my 1.1.5 backup. So I think all of those caused a problem.
But 1 big problem i still have. My user passwords. For some reason they don't work. I tried 5 different accounts and none of them worked. I had to create a new account, make it an admin and then retype my Main Admin password in for it to allow me to login. Is there a way to fix this? Because I don't want to have to reset all my member passwords?
Well did the conversion process go okay? Now the salt may be set differently between the version that is cause the miss match issues with passwords.
The conversion process went great and the upgrade process also upgraded my theme with it as well which is really cool. All the 2.0 features work in my 1.1.4 Theme.
There was no mix match issues.
I had both the 1.1.5 Forum files and the 1.1.5 Database. So I don't really get what is causing the problems with the passwords.
But this is no minor problem, cause I couldn't even log in.
------
I am also getting this little error: %1$d
"Users active in past %1$d minutes:"
I looked for that exact error and not one search came up for that problem. Unless I am looking for the wrong thing.