Current time: 03-18-2010, 10:55 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 2 Votes - 2.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL error enabling plugin
08-28-2008, 07:36 PM (This post was last modified: 08-28-2008 07:37 PM by Pekayz.)
Post: #1
SQL error enabling plugin
Hey there.

When I try to enable the CGI Chat plugin (seems to be compatible with 1.4 anyway since its in downloads again) I get this error;

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'horseworldforum.mybb_mybb_templates' doesn't exist
Query:
INSERT INTO mybb_mybb_templates (`tid`,`title`,`template`,`sid`) VALUES ('NULL','cgichat',' $headerinclude $header
Click "Enter Chat" below to enter the chat. You will be logged in as yourself if possible.

I'm not sure why it has double prefixes for mybb_ to be mybb_mybb_.
Find all posts by this user
Quote this message in a reply
08-30-2008, 12:05 AM
Post: #2
RE: SQL error enabling plugin
yeah try remove one of the mybb_ because the defult prefix is mybb_ in less you installed it with to mybb_. But if you remove on of the mybb_ in phpmyadmin it should work.
Find all posts by this user
Quote this message in a reply
09-03-2008, 08:16 PM
Post: #3
RE: SQL error enabling plugin
Nah sorry that didn't work, anyone else that knows how to fix this?
Find all posts by this user
Quote this message in a reply
09-03-2008, 08:31 PM (This post was last modified: 09-03-2008 08:32 PM by pepotiger.)
Post: #4
RE: SQL error enabling plugin
the plugin author using TABLE_PREFIX in his plugin
and this constant didn't supported in mybb 1.4
it's only supported in write_query method. but other db methods like simple_select, or update_query he didn't have to use the TABLE_PREFIX const

الدعم العربى
تطوير منتديات MyBB - كتب ودروس وملحقات الـ Php - دروس وكتب الـ XHTML - تطوير المواقع والمنتديات - ارسال الموقع الى محركات البحث - اشهار المواقع - برامج كمبيوتر - العاب كمبيوتر - برامج الجوالات وتعريبها
Cheap Web Hosting
Visit this user's website Find all posts by this user
Quote this message in a reply
09-29-2008, 01:10 PM (This post was last modified: 09-29-2008 01:11 PM by SLB.)
Post: #5
RE: SQL error enabling plugin
Anymore advice please?
(Pekayz is a friend of mine who is helping with the forum)

Bump Smile

[Image: minibanner.gif]
http://horseworldforum.co.uk/
Visit the Horse World Forum
Visit this user's website Find all posts by this user
Quote this message in a reply
09-29-2008, 09:24 PM
Post: #6
RE: SQL error enabling plugin
Like pepotiger said, look for something like $db->insert(TABLE_PREFIX.'templates', $new_template) and remove TABLE_PREFIX.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: