500 - An error has occured (when creating campaign)

More
23 Apr 2011 03:57 #953 by mattitp
joomlamailer version: 1.7
Joomla! version: 1.5.23 Stable
PHP version: 5.2.14
MySQL version: 5.1.52
Using hostgator via WHM panel.

I've just installed the mailchimp component and put in my mailchimp api etc.

It recognises my account as see's that I have pro membership and lists.

However, when I got to 'create campaign', the follow error screen comes up:
500 - An error has occurred.

DB function failed with error number 1146
Table 'inthepic_db.n8xiq_community_users' doesn't exist SQL=INSERT INTO `n8xiq_community_users` ( `userid`,`points`,`thumb`,`avatar`,`params` ) VALUES ( '91','0','','','notifyEmailSystem=1\nprivacyProfileView=0\nprivacyPhotoView=0\nprivacyFriendsView=0\nprivacyVideoView=1\nnotifyEmailMessage=1\nnotifyEmailApps=1\nnotifyWallComment=0\n' )

I want to integrate with community builder signups. I also have JFBC installed.

Can anyone advise? Can't work this out. Have gone into PHP MyAdmin and can confirm that there is indeed no table called community_users... what is this trying to refer to?

Any help would be much appreciated! :)

Please Log in or Create an account to join the conversation.

More
23 Apr 2011 16:25 #963 by pete
Hello mattitp,

The database table n8xiq_community_users is a JomSocial table. Maybe you uninstalled JomSocial and left some plugins enabled?
However, this sql query isn't done by joomlamailer. Also, when I go to the create page it's not processed even though I have JomSocial and Community Builder installed. So it must be one of your other installed extensions causing the conflict.
If you send me a superadmin login and ftp credentials for your site I can take a look at it what exactly is causing the error. pete@freakedout.de

Kind regards,
Pete

Please Log in or Create an account to join the conversation.