Arrow Home arrow Forums
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


Boardwalk :: Forum List CB 3PD uddeIM Plugin and Component
Re:(NO BUG,SOLVED) uddeim SQL error when sending
Date: 2008/04/30 17:53 By: gicug Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 9
graphgraph
Hello,

Thanks for your reply.
Yes i did as you said and pasted in this box this code with the code i found it in as is below:

SELECT * FROM `jos1_uddeim` WHERE 1ALTER TABLE `jos_uddeim` ADD `publicname` TEXT ;
ALTER TABLE `jos_uddeim` ADD `publicemail` TEXT ;
ALTER TABLE `jos_uddeim_emn` ADD `public` INT( 1 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `jos_uddeim_emn` ADD `lastsent` INT( 11 ) DEFAULT '0' NOT NULL ;
CREATE TABLE IF NOT EXISTS `jos_uddeim_userlists` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`userids` text NOT NULL,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM;

But i got this ERROR below:

Error
SQL query:

SELECT *
FROM `jos1_uddeim`
WHERE 1
ALTER TABLE `jos_uddeim` ADD `publicname` TEXT;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `jos_uddeim` ADD `publicname` TEXT' at line 2

Your help will be highly appreciated.

Thanks for your support.

Ronnie
Click here to see the profile of this user The administrator has disabled public write access.


      Topics Author Date
    thread link
(NO BUG) uddeim SQL error: Unknown column
MrPerez 2008/04/19 22:40
    thread link
thread linkthread link Re:uddeim SQL error when sending
slabbi 2008/04/19 22:41
    thread link
thread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
MrPerez 2008/04/19 23:05
    thread link
thread linkthread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
slabbi 2008/04/20 10:40
    thread link
thread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
gicug 2008/04/30 10:57
    thread link
thread linkthread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
MrPerez 2008/04/30 11:02
    thread link
thread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
gicug 2008/04/30 17:53
    thread link
thread linkthread linkthread link Re:(NO BUG,SOLVED) uddeim SQL error when sending
Canuck 2008/08/20 04:20
Boardwalk :: Forum List CB 3PD uddeIM Plugin and Component

Joomlaboard Forum Component 1.1.3 Stable
Two Shoes M-Factory

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC2)

What?

Why?

Where?

Just click here for answers!

Click here for a yearly subscription: subscribe now

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

The latest release candidate of Community Builder is version 1.2 RC3, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers at this time.

CB Login