Current time: 03-12-2010, 04:10 AM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem installing shoutbox
05-20-2009, 09:15 AM
Post: #1
Problem installing shoutbox
Shout box install error
Ok, I was installing the shoutbox plugin, after putting all the files where the install text document told me to. I have since checked this is right. I then tried to install the files and got this error message:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
42601 - ERROR: syntax error at or near "`" at character 17
Query:
CREATE TABLE `mybb_shouts` ( `sid` int(10) unsigned NOT NULL auto_increment, `uid` int(10) unsigned NOT NULL default '0', `message` text NOT NULL, `dateline` bigint(30) NOT NULL default '0', `ipaddress` varchar(30) NOT NULL default '', PRIMARY KEY (`sid`) ) TYPE=MyISAM


i am using version 1.4.6
using PostgreSQL 7.4.13 engine


I since tried to install a google analytics plugin and got a similar error, any idea what is wrong?
Find all posts by this user
Quote this message in a reply
05-20-2009, 09:24 AM
Post: #2
RE: Problem installing shoutbox
Probably wasn't tested on PostgreSQL so it's throwing an error.

My Personal Site - Twitter
MyBB Support Team
[Image: lqscs]
Visit this user's website Find all posts by this user
Quote this message in a reply
05-20-2009, 09:33 AM
Post: #3
RE: Problem installing shoutbox
is there any way I can get it to work? Or can I only use mods that have been tested on PostgreSQL?
Find all posts by this user
Quote this message in a reply
05-20-2009, 09:44 AM
Post: #4
RE: Problem installing shoutbox
I don't know anything about PostgreSQL syntax really, but it wouldn't hurt to try and remove the ` from the queries in the file; I don't know if it's those that are causing the error but they're mentioned, so that's where I'd start if it were happening to me.

My Personal Site - Twitter
MyBB Support Team
[Image: lqscs]
Visit this user's website Find all posts by this user
Quote this message in a reply
05-20-2009, 08:42 PM (This post was last modified: 05-20-2009 08:50 PM by xx50lashesxx.)
Post: #5
RE: Problem installing shoutbox
I dont know much about PostgreSQL either but can you take it out of strict mode.

I had similar problems with mysql
Find all posts by this user
Quote this message in a reply
07-05-2009, 06:56 PM
Post: #6
RE: Problem installing shoutbox
anything that says Type=MYISAM, and/or has `` around identifiers, will require extensive work to function on postgresql. I gave up on that MyShoutbox for this exact reason.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: