بسم الله الرحمن الرحيم
الرجاء المساعده
توقف المنتدى بسب مشكله الترميز تم ترميز قاعد البينات من صديق عنن طريق اسكريبت
قم بتركيب vb 4 بدون اى مشكه
وعندما رقيت المنتدى الى vb5
كثير من المشاكل فى لوحه التجكم فى اكثر من مكان لا استطيع حلها
مثلا// ادارة مجموعه الاعضاء
[PHP]
SELECT user.userid, reputation, username, usergroupid, birthday_search, email, parentemail, (options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, skype, signature, usertitle, joindate, lastpost, posts, ipaddress, lastactivity, userfield.*, infractions, ipoints, warnings, user.location, user.privacyconsent, user.privacyconsentupdated FROM user AS user LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) WHERE `user`.`usergroupid` = 4 ORDER BY `user`.`username` ASC LIMIT 0, 25 /** userFind**/;
استثناء الاستثناء :
## /home1//public_html/vb/core/vb/database.php(1208) Exception Thrown
#0 /home1//public_html/vb/core/vb/database/mysqli.php(249): vB_Database->halt()
#1 /home1//public_html/vb/core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 /home1//public_html/vb/core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\nS...', true)
#3 /home1//public_html/vb/core/vb/db/result.php(68): vB_dB_Result->rewind()
#4 /home1/public_html/vb/core/vb/db/querydefs.php(130): vB_dB_Result->__construct(Object(vB_Database_MySQLi), 'SELECT user.use...')
#5 /home1//public_html/vb/core/vb/db/mysql/querydefs.php(3373): vB_dB_QueryDefs->getResultSet(Object(vB_Database_MySQLi), 'SELECT user.use...', 'userFind')
#6 /home1//public_html/vb/core/vb/db/query/method.php(175): vB_dB_MYSQL_QueryDefs->userFind(Array, Object(vB_Database_MySQLi), false, false)
#7 /home1//public_html/vb/core/vb/db/assertor.php(293): vB_dB_Query_Method->execSQL()
#8 /home1//public_html/vb/core/vb/db/assertor.php(641): vB_dB_Assertor->assertQuery('userFind', Array, false)
#9 /home1//public_html/vb/core/vb/api/user.php(1032): vB_dB_Assertor->getRows('userFind', Array)
#10 /home1//public_html/vb/core/admincp/user.php(1616): vB_Api_User->find(Array, Array, 'username', 'ASC')
#11 /home1//public_html/vb/includes/api/interface/collapsed.php(147): require_once('/home1/oneoneo6...')
#12 /home1//public_html/vb/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/user.ph...')
#13 /home1//public_html/vb/index.php(74): vB5_Frontend_Controller_Relay->admincp('user.php')
#14 {main}
[/PHP]
اماكن كثيره
[PHP] Error Invalid SQL: SELECT `locationid`,`title` FROM location ORDER BY `title`;
استثناء الاستثناء :
## /home1//public_html/vb/core/vb/database.php(1208) Exception Thrown
#0 /home1//public_html/vb/core/vb/database/mysqli.php(249): vB_Database->halt()
#1 /home1/6/public_html/vb/core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 /home1//public_html/vb/core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\nS...', true)
#3 /home1//public_html/vb/core/vb/db/result.php(68): vB_dB_Result->rewind()
#4 /home1//public_html/vb/core/vb/db/query/select.php(121): vB_dB_Result->__construct(Object(vB_Database_MySQLi), 'SELECT `locatio...', false)
#5 /home1//public_html/vb/core/vb/db/query/select.php(98): vB_dB_Query_Select->doSelect()
#6 /home1//public_html/vb/core/vb/db/assertor.php(293): vB_dB_Query_Select->execSQL()
#7 /home1//public_html/vb/core/vb/db/assertor.php(641): vB_dB_Assertor->assertQuery('location', Array, 'title')
#8 /home1//public_html/vb/core/vb/library/options.php(168): vB_dB_Assertor->getRows('location', Array, 'title', 'locationid')
#9 /home1//public_html/vb/core/vb/api/options.php(932): vB_Library_Options->getLocationList(NULL)
#10 /home1//public_html/vb/core/admincp/locations.php(231): vB_Api_Options->getLocationList()
#11 /home1//public_html/vb/includes/api/interface/collapsed.php(147): require_once('/home1/oneoneo6...')
#12 /home1//public_html/vb/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/locatio...')
#13 /home1/public_html/vb/index.php(74): vB5_Frontend_Controller_Relay->admincp('locations.php')
#14 {main}
[/PHP]
الرجاء المساعده
توقف المنتدى بسب مشكله الترميز تم ترميز قاعد البينات من صديق عنن طريق اسكريبت
قم بتركيب vb 4 بدون اى مشكه
وعندما رقيت المنتدى الى vb5
كثير من المشاكل فى لوحه التجكم فى اكثر من مكان لا استطيع حلها
مثلا// ادارة مجموعه الاعضاء
[PHP]
SELECT user.userid, reputation, username, usergroupid, birthday_search, email, parentemail, (options & 8) AS coppauser, homepage, icq, aim, yahoo, msn, skype, signature, usertitle, joindate, lastpost, posts, ipaddress, lastactivity, userfield.*, infractions, ipoints, warnings, user.location, user.privacyconsent, user.privacyconsentupdated FROM user AS user LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) WHERE `user`.`usergroupid` = 4 ORDER BY `user`.`username` ASC LIMIT 0, 25 /** userFind**/;
استثناء الاستثناء :
## /home1//public_html/vb/core/vb/database.php(1208) Exception Thrown
#0 /home1//public_html/vb/core/vb/database/mysqli.php(249): vB_Database->halt()
#1 /home1//public_html/vb/core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 /home1//public_html/vb/core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\nS...', true)
#3 /home1//public_html/vb/core/vb/db/result.php(68): vB_dB_Result->rewind()
#4 /home1/public_html/vb/core/vb/db/querydefs.php(130): vB_dB_Result->__construct(Object(vB_Database_MySQLi), 'SELECT user.use...')
#5 /home1//public_html/vb/core/vb/db/mysql/querydefs.php(3373): vB_dB_QueryDefs->getResultSet(Object(vB_Database_MySQLi), 'SELECT user.use...', 'userFind')
#6 /home1//public_html/vb/core/vb/db/query/method.php(175): vB_dB_MYSQL_QueryDefs->userFind(Array, Object(vB_Database_MySQLi), false, false)
#7 /home1//public_html/vb/core/vb/db/assertor.php(293): vB_dB_Query_Method->execSQL()
#8 /home1//public_html/vb/core/vb/db/assertor.php(641): vB_dB_Assertor->assertQuery('userFind', Array, false)
#9 /home1//public_html/vb/core/vb/api/user.php(1032): vB_dB_Assertor->getRows('userFind', Array)
#10 /home1//public_html/vb/core/admincp/user.php(1616): vB_Api_User->find(Array, Array, 'username', 'ASC')
#11 /home1//public_html/vb/includes/api/interface/collapsed.php(147): require_once('/home1/oneoneo6...')
#12 /home1//public_html/vb/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/user.ph...')
#13 /home1//public_html/vb/index.php(74): vB5_Frontend_Controller_Relay->admincp('user.php')
#14 {main}
[/PHP]
اماكن كثيره
[PHP] Error Invalid SQL: SELECT `locationid`,`title` FROM location ORDER BY `title`;
استثناء الاستثناء :
## /home1//public_html/vb/core/vb/database.php(1208) Exception Thrown
#0 /home1//public_html/vb/core/vb/database/mysqli.php(249): vB_Database->halt()
#1 /home1/6/public_html/vb/core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 /home1//public_html/vb/core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\nS...', true)
#3 /home1//public_html/vb/core/vb/db/result.php(68): vB_dB_Result->rewind()
#4 /home1//public_html/vb/core/vb/db/query/select.php(121): vB_dB_Result->__construct(Object(vB_Database_MySQLi), 'SELECT `locatio...', false)
#5 /home1//public_html/vb/core/vb/db/query/select.php(98): vB_dB_Query_Select->doSelect()
#6 /home1//public_html/vb/core/vb/db/assertor.php(293): vB_dB_Query_Select->execSQL()
#7 /home1//public_html/vb/core/vb/db/assertor.php(641): vB_dB_Assertor->assertQuery('location', Array, 'title')
#8 /home1//public_html/vb/core/vb/library/options.php(168): vB_dB_Assertor->getRows('location', Array, 'title', 'locationid')
#9 /home1//public_html/vb/core/vb/api/options.php(932): vB_Library_Options->getLocationList(NULL)
#10 /home1//public_html/vb/core/admincp/locations.php(231): vB_Api_Options->getLocationList()
#11 /home1//public_html/vb/includes/api/interface/collapsed.php(147): require_once('/home1/oneoneo6...')
#12 /home1//public_html/vb/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/locatio...')
#13 /home1/public_html/vb/index.php(74): vB5_Frontend_Controller_Relay->admincp('locations.php')
#14 {main}
[/PHP]
تعليق