SMF Support > SMF 2.0.x Support
Error in database (?)
GUNNERPT:
Hello,
Last Monday I made a full backup of my website / SMF forum 2.0.2, and then i found that when people try to post a youtube link in the forum, they get the following error:
--- Quote ---Warning: mysql_real_escape_string () expects parameter 2 to be resource, boolean Given in / home / *** / public_html / forum / Sources / Subs-Db-mysql.php on line 140
--- End quote ---
I tried to repair the database using the "repair database" function in the CPanel., but it didn't work.
Oh ... Before making the backup I have eliminated some .core files that has emerged in my website
I contacted my webhost service and they suggested to me that I should check the error_log file to see what were the errors that were causing those .core files. And then i should fix those errors.
Well ... The file is full of errors like the one i quoted above. I don't have any idea how to fix it.
I discovered that it was not possible to post new videos from youtube in the forum, but I noticed that those videos who had been previously posted were still working properly.
I uninstalled Aeva Media Gallery and then i found that it was possible to post new links again, but it was not possible to watch any youtube videos inside of the forum.
So I installed AEVA Lite and found that it returned to the situation before: i can watch the videos previously posted, but it is not possible to post new links.
I don't know whta else i can do ... this situation causes huge inconvenience to my forum. :(
Can anyone, please, help me?
Thank you.
Storman™:
--- Quote ---Oh ... Before making the backup I have eliminated some .core files that has emerged in my website
--- End quote ---
Can you elaborate on that point. No idea what you are referring to ?
--- Quote ---I uninstalled Aeva Media Gallery and then i found that it was possible to post new links again, but it was not possible to watch any youtube videos inside of the forum.
So I installed AEVA Lite and found that it returned to the situation before: i can watch the videos previously posted, but it is not possible to post new links.
--- End quote ---
Sounds like your issue relates to the Aeva mod so you really need to post in the mod's own topic located here
I've seen that issue before with Aeva which seems to relate to a mismatch between versions, especially when uninstalling and reinstalling. If you look in the Aeva topic I think there's something about it somewhere in there.
Think these are two separate issues that are unrelated though.
Arantor:
-sigh- It isn't an issue with Aeva. It is almost certainly an issue with other mods conflicting with Aeva that causes the links problem.
.core files are where the webserver crashes, very often related to host configuration issues.
Also, with respect to the database issue, that is NOT Aeva related. That is related to an issue with MySQL itself and searching for that exact error would find you a lengthy discussion as to what causes it and a fix from me to the code to prevent it.
GUNNERPT:
Tks.
I don't think it is an Aeva problem, too. But ... i didn't install any mod recently ... i don't understand why this is happening now. These are de mods i got installed in my SMF:
1. SMF Arcade 2.5 RC1.1C
2. Aeva ~ Auto-Embed Video & Audio 7.2
3. SMF 2.0.1 Update 1.0
4. AjaxChat Integration 3.2.1 (modified for SMF 2 RC3)
5. SMF 2.0.2 Update 1.0
6. Spoiler Tag 0.7.2a
I'm using SMF 2.0.2 (pt_pt); Theme BlackBox by Crip.
I'm attaching de error_log files from my website: home (joomla); forum (SMF); chat (ajax); and the .php file. I don't know if i can leave here any other information so somebody can help me.
I googled for this error and i found another topic like this (http://www.simplemachines.org/community/index.php?topic=423482.0), but it is about an error in the line 143, not in the line 140 (like in my case).
I saw there people talking about changing code ... OMG, i don't understand nothing about those codes :(
There's anything else i can do? I remember a SMF tool called repair_settings, can this be usefull? Should i re-install SMF? I don't want to lose a forum with 470 member, 2314 topics and 116899 msgs.
:(
MrPhil:
The "home" errors list lots of "rvs" errors. That has nothing to do with SMF. There are also "out of memory" errors -- can you work with your host to increase your allocated memory size for PHP? You appear to have a very small amount allowed. You're also running Joomla, which is going to demand a lot of memory.
I see a lot of "aba_portal_in" undefined index errors. Did you try installing, or try removing, some sort of portal? If so, the job was incomplete. You will need to "parse" the mod install instructions and manually fix the code (a tough job if you can't even spell PHP!).
I saw one or two "cache" errors (missing cache file). When you get those, you need to go to the SMF cache directory and erase all .php files there. If you keep having problems, just turn off SMF caching. It's often more trouble than it's worth.
repair_settings probably isn't going to help with any of the errors you're seeing. Neither probably will phpMyAdmin's CHECK and REPAIR utilities (although it wouldn't hurt to CHECK for any database problems, and fix them if found). Worst case, you can get the "Large upgrade" package and overwrite all your SMF .php files with fresh copies, and then install your mods again. That should cure the aba_portal_in problem. Needless to say, back up your files and database (using phpMyAdmin) first, and don't use FileZilla until you understand how to force it to properly handle extension-less files.
Navigation
[0] Message Index
[#] Next page
Go to full version