Завершено

Vbulletin Expert Needed

Note:? Here is additional information:

**OK, this is what I found out.? ? We had a plugin installed on the site called 'Miserable Users'? and one of the admins tried to add an user to that particliar addin as he was causing trouble.

The IP address showing up in the database error is the ip address that the admin was trying add to miserable users.? ? ? But if memory serves me the system asked for userid rather than IP.? ? That is all I have to go on for now.

**

We currently run Vbulletin 3.7.2 at? <[url removed, login to view]>? and after the first of the year is started having database issues.? ? Here is a sampling of one of errors:

Database error in vBulletin 3.7.2:

Invalid SQL:

? ? ? SELECT MIN(postid) AS postid

? ? ? FROM post

? ? ? WHERE threadid = 145124

? ? ? ? AND visible = 1

? ? ? ? AND dateline > 1231199902

? ? ? ? AND userid NOT IN (35548,,[url removed, login to view])

? ? ? 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 '[url removed, login to view])

? ? ? LIMIT 1' at line 6

Error Number? : 1064

Request Date? : Monday, January 5th 2009 @ 04:02:30 PM

Error Date? ? ? : Monday, January 5th 2009 @ 04:02:30 PM

Script? ? ? ? ? ? ? : <[url removed, login to view]>

Referrer? ? ? ? ? : <[url removed, login to view]>

IP Address? ? ? :

Username? ? ? ? ? :

Classname? ? ? ? : vB_Database

MySQL Version : [url removed, login to view]

Currently Mods are able to post, but users can not.

Квалификация: Техника, Linux, MySQL, PHP, Управление проектами, Архитектура ПО, Тестирование ПО, Веб-хостинг, Управление сайтами, Тестирование веб-сайтов

Показать больше sampling, vbulletin php mysql, php sql syntax error, 1064 php, database error linux server, sql syntax error, php mysql 1064, dateline, mysql sql syntax, system admin expert, date monday, error sql syntax site, sql syntax, error mysql memory needed, manual forum post, showthread vbulletin, error 1064, mysql error 1064, sql select script, forum post address

О работодателе:
( 59 отзыв(-а, -ов) ) Redmond, United States

ID проекта: #3518871

Поручен:

abailissvw

See private message.

$32.3 USD за 3 дней(-я)
(33 отзывов(-а))
4.5

2 фрилансеров(-а) в среднем готовы выполнить эту работу за $42

mzgymunt

See private message.

$51 USD за 3 дней(-я)
(556 отзывов(-а))
6.4