|
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? |
|||
|
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 |
|||
|
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?
|
|||
|
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 |
|||
|
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 |
|||
|
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.
|
|||
|
« Next Oldest | Next Newest »
|
Search
Member List
Calendar
Help



