إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...

انضم الينا
استراحات زايد الصفحة الرئيسية


 
 
LinkBack أدوات الموضوع انواع عرض الموضوع
  #1  
قديم 01-09-2010, 03:40 AM
عضو ماسي
بيانات محروم.كوم
 رقم العضوية : 503
 تاريخ التسجيل : Dec 2007
الجنس : female
علم الدوله :
 المشاركات : 2,100,669
عدد الـنقاط :3341
 تقييم المستوى : 2140

Hi

I logged into my forum earlier this morning to user's reporting database erros when trying to post. Having looked into the problem there seems to be at least 3 different database errors occuring.

The first occurs when a user clicks on the last post when in the main forum view. (the bit which shows the last post for every induvidual forum). I can view threads if i click into a forum and then onto the thread.

There error message is:
Code:
Database error in vBulletin 3.7.1:
Invalid SQL:
SELECT MIN(postid) AS postid
FROM post
WHERE threadid = 3824
AND visible = 1
AND dateline > 1262987214
AND userid NOT IN (212.235.107.70)
LIMIT 1;
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 '.107.70)
LIMIT 1' at line 6
Error Number : 1064
Request Date : Friday, January 8th 2010 @ 06:18:10 PM
Error Date : Friday, January 8th 2010 @ 06:18:10 PM
Script : http://www.wrestling-365.com/forum/s...newpost&t=3824
Referrer : http://www.wrestling-365.com/forum/
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
A second message appears when click on 'Post a Reply' when viewing a thread. However, no error occurs while using 'Quick Reply' to post a message.

The error message:
Code:
Database error in vBulletin 3.7.1:
Invalid SQL:
SELECT post.*, IF(post.userid = 0, post.username, user.username) AS username
FROM post AS post
LEFT JOIN user AS user ON (user.userid = post.userid)
WHERE post.visible = 1
AND post.userid NOT IN (212.235.107.70)
AND post.threadid = 3914
ORDER BY dateline DESC, postid DESC
LIMIT 11;
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 '.107.70)

AND post.threadid = 3914
ORDER BY dateline DESC, postid DESC
LI' at line 5
Error Number : 1064
Request Date : Friday, January 8th 2010 @ 06:25:37 PM
Error Date : Friday, January 8th 2010 @ 06:25:38 PM
Script : http://www.wrestling-365.com/forum/n...uote=1&p=43369
Referrer : http://www.wrestling-365.com/forum/s...ead.php?t=3914
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
Error message when trying to delete a post:
Code:
Database error in vBulletin 3.7.1:
Invalid SQL:
SELECT
SUM(IF(visible = 1, attach, 0)) AS attachsum,
SUM(IF(visible = 1, 1, 0)) AS visible,
SUM(IF(visible = 0, 1, 0)) AS hidden,
SUM(IF(visible = 2, 1, 0)) AS deleted
FROM post AS post
WHERE threadid = 3914
AND post.userid NOT IN (212.235.107.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 '.107.70)' at line 8
Error Number : 1064
Request Date : Friday, January 8th 2010 @ 06:19:25 PM
Error Date : Friday, January 8th 2010 @ 06:19:25 PM
Script : http://www.wrestling-365.com/forum/editpost.php
Referrer : http://www.wrestling-365.com/forum/s...ed=1#post43372
IP Address : 88.105.36.213
Username : Muxx
Classname : vB_Database
MySQL Version : 5.0.67-community
There may be more errors that i havn't found yet.

All help is appreciated. Thanks
__DEFINE_LIKE_SHARE__
رد مع اقتباس
 

مواقع النشر (المفضلة)


تعليمات المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code is متاحة
كود [IMG] متاحة
كود HTML معطلة
Trackbacks are متاحة
Pingbacks are متاحة
Refbacks are متاحة



الساعة الآن 07:36 PM


Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By Almuhajir

RSS RSS 2.0 XML MAP HTML