Hi, i recently discovered this problem..
When i click the last post of the forum, i got this error message
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 '' at line 1
Query:
SELECT * FROM mybb_forums WHERE fid =
It happens in all forums, and only with the last thread function
I have google seo installed, i try to deactivate it but it is still the same result
Any ideas?
PD: My board was coverted from phpbb3 some days ago and i recently migrated from localhost to a server
Thanks
Could you please copy the whole URL from the page you got this error?
Is it possible that you forgot to add something to the .htaccess file?
I guess your .htaccess is kinda destroyed.
Could you post it here? In that case we could try to find the error
Have you edited the rewrite rules because post-X.html#pidX isn't a default rule, you could get the default one back by copying it from the default htaccess.txt from the MyBB package.
Sure, this is the .htaccess
Quote:Options -MultiViews +FollowSymlinks -Indexes
#
# If mod_security is enabled, attempt to disable it.
# - Note, this will work on the majority of hosts but on
# MediaTemple, it is known to cause random Internal Server
# errors. For MediaTemple, please remove the block below
#
<IfModule mod_security.c>
# Turn off mod_security filtering.
SecFilterEngine Off
# The below probably isn't needed, but better safe than sorry.
SecFilterScanPOST Off
</IfModule>
# Google SEO 404:
ErrorDocument 404 /MyBB/misc.php?google_seo_error=404
#
# MyBB "search engine friendly" URL rewrites
# - Note, for these to work with MyBB please make sure you have
# the setting enabled in the Admin CP and you have this file
# named .htaccess
#
<IfModule mod_rewrite.c>
RewriteEngine on
# Google SEO workaround for search.php highlights:
# Make this rule the first rewrite rule in your .htaccess!
RewriteRule ^([^&]*)&(.*)$ http://localhost/MyBB/1405/$1?$2 [L,QSA,R=301]
# Google SEO Sitemap:
RewriteRule ^sitemap-([^./]+)\.xml$ misc.php?google_seo_sitemap=$1 [L,QSA,NC]
# Google SEO URL Forums:
RewriteRule ^Forum-([^./]+)$ forumdisplay.php?google_seo_forum=$1 [L,QSA,NC]
# Google SEO URL Threads:
RewriteRule ^Thread-([^./]+)$ showthread.php?google_seo_thread=$1 [L,QSA,NC]
# Google SEO URL Announcements:
RewriteRule ^Announcement-([^./]+)$ announcements.php?google_seo_announcement=$1 [L,QSA,NC]
# Google SEO URL Users:
RewriteRule ^User-([^./]+)$ member.php?action=profile&google_seo_user=$1 [L,QSA,NC]
# Google SEO URL Calendars:
RewriteRule ^Calendar-([^./]+)$ calendar.php?google_seo_calendar=$1 [L,QSA,NC]
# Google SEO URL Events:
RewriteRule ^Event-([^./]+)$ calendar.php?action=event&google_seo_event=$1 [L,QSA,NC]
# Default MyBB Rewrite Rules:
RewriteRule ^forum-([0-9]+)\.html$ forumdisplay.php?fid=$1 [L,QSA]
RewriteRule ^forum-([0-9]+)-page-([0-9]+)\.html$ forumdisplay.php?fid=$1&page=$2 [L,QSA]
RewriteRule ^thread-([0-9]+)\.html$ showthread.php?tid=$1 [L,QSA]
RewriteRule ^thread-([0-9]+)-page-([0-9]+)\.html$ showthread.php?tid=$1&page=$2 [L,QSA]
RewriteRule ^thread-([0-9]+)-lastpost\.html$ showthread.php?tid=$1&action=lastpost [L,QSA]
RewriteRule ^thread-([0-9]+)-nextnewest\.html$ showthread.php?tid=$1&action=nextnewest [L,QSA]
RewriteRule ^thread-([0-9]+)-nextoldest\.html$ showthread.php?tid=$1&action=nextoldest [L,QSA]
RewriteRule ^thread-([0-9]+)-newpost\.html$ showthread.php?tid=$1&action=newpost [L,QSA]
RewriteRule ^thread-([0-9]+)-post-([0-9]+)\.html$ showthread.php?tid=$1&pid=$2 [L,QSA]
RewriteRule ^post-([0-9]+)\.html$ showthread.php?pid=$1 [L,QSA]
RewriteRule ^announcement-([0-9]+)\.html$ announcements.php?aid=$1 [L,QSA]
RewriteRule ^user-([0-9]+)\.html$ member.php?action=profile&uid=$1 [L,QSA]
RewriteRule ^calendar-([0-9]+)\.html$ calendar.php?calendar=$1 [L,QSA]
RewriteRule ^calendar-([0-9]+)-year-([0-9]+)\.html$ calendar.php?action=yearview&calendar=$1&year=$2 [L,QSA]
RewriteRule ^calendar-([0-9]+)-year-([0-9]+)-month-([0-9]+)\.html$ calendar.php?calendar=$1&year=$2&month=$3 [L,QSA]
RewriteRule ^calendar-([0-9]+)-year-([0-9]+)-month-([0-9]+)-day-([0-9]+)\.html$ calendar.php?action=dayview&calendar=$1&year=$2&month=$3&day=$4 [L,QSA]
RewriteRule ^calendar-([0-9]+)-week-(n?[0-9]+)\.html$ calendar.php?action=weekview&calendar=$1&week=$2 [L,QSA]
RewriteRule ^event-([0-9]+)\.html$ calendar.php?action=event&eid=$1 [L,QSA]
<IfModule mod_env.c>
SetEnv SEO_SUPPORT 1
</IfModule>
</IfModule>
#
# If Apache is compiled with built in mod_deflade/GZIP support
# then GZIP Javascript, CSS, HTML and XML so they're sent to
# the client faster.
#
<IfModule mod_deflate.c>
AddOutputFilterByType DEFLATE application/x-javascript text/css text/html text/xml
</IfModule>
# Google SEO workaround for search.php highlights:
# Make this rule the first rewrite rule in your .htaccess!
RewriteRule ^([^&]*)&(.*)$ http://www.facebookerss.com.ar/$1?$2 [L,QSA,R=301]
# Google SEO 404:
ErrorDocument 404 /misc.php?google_seo_error=404
And this is a list of plugins installed
Quote:(1.0)
Add Spiders (0.1)
Admins can log into Users' accounts (1.0)
Admin Post Edit (1.0)
Advanced Quick Reply Form (1.0.3)
Country Flag (2.1)
Default Profile (2.1.0)
Disable right click for guests (1.0)
Dynamic Metas (1.1)
Email about new members (2.0.0)
FancyZoom (1.1)
Google SEO (1.1.4)
Guests and lurkers combined message2 (2.0)
* imei Page Optimizer! (1.0.1)
Locked Thread Quick Reply Warning (1.0)
Login Password Conversion (1.0)
Mini SQL (1.0)
Miss You Email (1.0.0)
MyShoutbox 1.2 (1.1)
Online Today (1.1)
PHP and Template Conditionals (1.3)
Private Messages Admin (2.4.1)
Profile Comments (0.4.1)
Facebook profile link on Postbit (2.1)
Sitemap Generator (1.4.0RC2)
User Appearance (0.3)
(2009-07-23, 09:35 PM)MattRogowski Wrote: [ -> ]Have you edited the rewrite rules because post-X.html#pidX isn't a default rule, you could get the default one back by copying it from the default htaccess.txt from the MyBB package.
I replace my .htaccess file with the default that comes in mybb package and the error continue.
thanks
(2009-07-23, 09:36 PM)Likee Wrote: [ -> ] (2009-07-23, 09:35 PM)MattRogowski Wrote: [ -> ]Have you edited the rewrite rules because post-X.html#pidX isn't a default rule, you could get the default one back by copying it from the default htaccess.txt from the MyBB package.
I replace my .htaccess file with the default that comes in mybb package and the error continue.
thanks
Did you just upload the default one from the MyBB package, didn't rename it...?? Because the default one is called htaccess.txt, not .htaccess... delete your current .htaccess and rename the defalt htaccess.txt to .htaccess