Database Error In Vbulletin 4.1.5 Invalid Sql
Database Error Register Help Members List Today's Posts Search Quick Links Thread Tools #1 29 Jul 2011, 13:04 Lynessa Member Join Date: Mar 2011 Database Error Datenbankfehler in vBulletin 4.1.4: Invalid SQL: INSERT INTO pt_projectpermission (usergroupid, projectid, issuetypeid, generalpermissions, postpermissions, attachpermissions) VALUES (1, 0, 'bug', 65555, 0, 1),(1, 0, 'feature', 65555, 0, 1),(1, 0, 'task', 65555, 0, 1); MySQL-Fehler : Duplicate entry '1-0-bug' for key 1 Fehler-Nr. : 1062 Klassenname : vB_Database MySQL-Version : 5.0.92 Can anyone help me with this error? No members have liked this post. Lynessa View Public Profile Find all posts by Lynessa Comments #2 29 Jul 2011, 13:41 Disasterpiece Coder Join Date: Apr 2007 When does it appear? Is it reproduceable? No members have liked this post. Disasterpiece View Public Profile Visit Disasterpiece's homepage! Find all posts by Disasterpiece Likes Received: 76 #3 29 Jul 2011, 14:01 Lynessa Member Join Date: Mar 2011 It apperas when i want to add the whole thing to the products No members have liked this post. Lynessa View Public Profile Find all posts by Lynessa #4 29 Jul 2011, 19:31 PitchouneN64ngc IB Staff Join Date: Aug 2002 Real name: Yves This type of error appears when you have already installed it (or tried to install it) and you did it twice without overwriting the installed non-referenced product. Have you already tried to install it? It was an update of a previous install? __________________ Administrator of http://forum.vbulletin-fr.org/ vBulletin QA Engineer / Lead Project Tools Developer No members have liked this post. PitchouneN64ngc View Public Profile Visit PitchouneN64ngc's homepage! Find all posts by PitchouneN64ngc Likes Received: 31 #5 29 Jul 2011, 21:40 Lynessa Member Join Date: Mar 2011 Ok i have deleted the old table but now there is the following error Invalid SQL: INSERT INTO cms_widgettype (class, packageid) VALUES ('RecentPTIssues', ), ('RecentPTComments', ); MySQL-Fehler : You have a
in vBulletin 4.1.5: Invalid SQL: SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users , user.market_username_color, user.market_username_glow, market_username_subscript FROM session as session WHERE session.lastactivity > 1316390092 GROUP BY isuser; MySQL Error : Unknown column 'user.market_username_color' in 'field list' Error Number : 1054 Request Date : Monday, September 19th 2011 @ 04:09:52 AM Error Date : https://www.vbulletin.org/forum/showthread.php?t=267618 Monday, September 19th 2011 @ 04:09:52 AM Script : http://www.yourdomain.com/online.php Referrer : http://www.yourdomain.com/forum.php IP Address : xx.xx.xx.xxx Username : xxxxx Classname : vB_Database MySQL Version : xxxxx HMBeaty19 Sep 2011, 00:22That error is from a modification. Possibly the vBBux/VBPlaza mod? or some type of market modification.... SPEEDKILLZ19 Sep http://www.vbulletin.org/forum/archive/index.php/t-270534.html 2011, 00:28I have ucash? what should i do? But when i disable it and reload there is still an error HMBeaty19 Sep 2011, 00:33Disable it and ask/search in the modifications thread for a fix SPEEDKILLZ19 Sep 2011, 00:34ok it is the point market thanks wheretobet27 Sep 2011, 10:31I get this when i click the whos online (12users) link Database error in vBulletin 4.1.5: Invalid SQL: SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users , user.market_username_color, user.market_username_glow, market_username_subscript FROM session as session WHERE session.lastactivity > 1316390092 GROUP BY isuser; this bug is caused by Point Market. You can disable the plugin OR you can comment/delete the hook causing the error in the online.php open online.php at line 280 remove this line of code $hook_query_fields thats it! and boom goes the dynamite vBulletin v3.8.10 Beta 2, Copyright ©2000-2016, vBulletin Solutions, Inc.
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum http://www.dbforums.com/showthread.php?1669161-MySQL-Error-1054-Vbulletin-4-1-5 that you want to visit from the selection below. Results 1 to 10 of 10 http://www.dragonbyte-tech.com/f94/serious-database-error-after-uninstall-mod-4959/ Thread: MySQL Error 1054 Vbulletin 4.1.5 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-13-11,14:12 #1 225 View Profile View Forum Posts Registered User Join Date Aug 2011 Posts 6 Unanswered: MySQL Error 1054 Vbulletin 4.1.5 Can someone please database error help me with this. I have contacted the author of the program and he says it's a overwrite issue? Database error in vBulletin 4.1.5: Invalid SQL: INSERT INTO `dbtech_vbshout_instance` (`name`, `description`, `active`, `autodisplay`, `deployment`, `templates`, `permissions`) VALUES ( 'Shoutbox', 'This is the default Shoutbox. You can change this description by clicking [Edit].', 1, 1, 'index', '', 'a:8:{i:2;i:2108;i:6;i:4092;i:4;i:12;i:8;i:0;i:7;i :3964;i:5;i:4092;i:1;i:4;i:3;i:12;}' ); MySQL Error : Unknown column 'deployment' in 'field list' Error Number : database error in 1054 Request Date : Saturday, August 13th 2011 @ 04:26:42 AM Error Date : Saturday, August 13th 2011 @ 04:26:51 AM Script : Log in - Extreme SMX - vBulletin Admin Control Panel Referrer : Log in - Extreme SMX - vBulletin Admin Control Panel IP Address : Username : Classname : vB_Database MySQL Version : 5.1.52 Reply With Quote 08-13-11,18:46 #2 r937 View Profile View Forum Posts Visit Homepage SQL Consultant Join Date Apr 2002 Location Toronto, Canada Posts 20,002 can you go to your mysql database and run the following query Code: SHOW CREATE TABLE dbtech_vbshout_instance rudy.ca | @rudydotca Buy my SitePoint book: Simply SQL Reply With Quote 08-14-11,01:15 #3 225 View Profile View Forum Posts Registered User Join Date Aug 2011 Posts 6 I will try and let you know. Thanks for the help. Reply With Quote 08-14-11,01:25 #4 225 View Profile View Forum Posts Registered User Join Date Aug 2011 Posts 6 http://i142.photobucket.com/albums/r...ee1006/php.jpg Ran XML script afterwards.... Same error. File I am trying to run on my vBulletin Forum: http://www.megaupload.com/?d=ORZYW9BU Let me know if you need the files I have to upload to my db. This is what I am trying to do: http://www.vbulletin.org/forum/showt...hlight=chatbox Last edited by 225; 08-14-11 at 01:31. Reply With Quote 08-14-11,02:42 #5 r937 View Profi
made mods, skins and customizations for vBulletin and custom skins for IPB and xenForo. Click here for info. Become one of our happy customers In addition to our testimonial box, we have also conducted surveys of customer satisfaction. The result? 98% of customers would recommend us to a friend. Serving some of your favourite companies Have you seen our "Also Runs On" box? Companies like the Curse Network, Tom's Hardware, Gearbox Software and XDA Developers rely on DragonByte Tech for their forum improvement needs. Want to test our full range of products? You can visit DBTechs alternate site - www.DBTech.co and browse and post as normal but with the added bonus of being able to access and try all of our products. Join In Our Feedback Surveys You can sign up to receive our infrequent surveys which help us by giving us invaluable feedback on how you, our customers, feel about various parts of our service and our upcoming plans. You also get entered into exclusive prize draws! Click here to sign up! Store Forum New Posts Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders Live Streams vBActivity Mailing Lists User Tagging Statistics Hash Tag Subscriptions Thanks / Like Statistics Hottest Threads / Posts Custom Work Site Directory Member Map Classifieds Live Streams What's New? Search Forum DragonByte Technologies Product Support vBQuiz vBQuiz Lite Support Serious database error after uninstall of mod If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. We have recently been made aware that servers using the "BoxTrapper" anti-spam measure will not receive our emails, because BoxTrapper sends the verification email to a non-existent email address. In order to ensure you will receive our emails, please add dragonbyte-tech.com to your BoxTrapper Whitelist as per the documentation before attempting to register to DBTech or purchasing from us. Sorry for the inconvenience. - DragonByte Tech Staff User Tag List Thanks: 1 Post #29408 (1) Likes: 2 Post #29408 (1)Post #29430 (1) Dislikes: 0 Page 1 of 4 123 ... Last Jump to page: Results 1 to 10 of 37 Thread: Serious database error after uninstall of mod Forum: vBQuiz Lite Support Questions & Answers for vBQuiz. Click here to buy! Thread Tools Show Printable Version Email this Page… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 19th September 2011,00:04