Već par dana se vrtim oko problema sa bazom podataka u lokalu. U pitanju je skripta vBulletin 4.2.0 i uključio sam blog nedavno da testiram. U meniju se lepo pojavi stavka Blog, ali kad kliknem na nju izlazi mi obaveštenje da postoji greška u MySQL bazi.
Proverio sam da nema slučajno znakova ` umesto ' , i još nekoliko grešaka o kojima se pisalo na Internetu a vezano za grešku 1064. Ništa nisam mogao primenuti ovde na ovome što sad pokušavam osposobiti.
Kôd:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM vb_tagcontent AS tagcontent
INNER JOIN vb_tag AS tag ON (tagcontent.tagid = tag.tagid)
INNER JOIN vb_blog AS blog ON (tagcontent.contenttypeid = AND tagcontent.contentid = blog.blogid)
INNER JOIN vb_blog_user AS blog_user ON (blog.userid = blog_user.bloguserid)
WHERE blog.dateline <= 1346962196 AND blog.pending = 0 AND blog.state = 'visible' AND ~blog.options & 8 AND blog.userid NOT IN (631,7430,1921,10577,10997,13780)
AND tagcontent.dateline > 1315426196
GROUP BY tagcontent.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;
MySQL Error : 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 'AND tagcontent.contentid = blog.blogid)
INNER JOIN vb_blog_user AS blog_user' at line 4
Error Number : 1064
Request Date : Thursday, September 6th 2012 @ 08:09:56 PM
Error Date : Thursday, September 6th 2012 @ 08:09:57 PM
Script : http://localhost/blog.php
Referrer : http://localhost/forum.php
IP Address : 127.0.0.1
Username : novii
Classname : vB_Database
MySQL Version : 5.5.24-log