|
|
|
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 |   |
|
|
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
|
|
The administrator has disabled public write access. |
|
 |
|
Re:(NO BUG,SOLVED) uddeim SQL error when sending
|
|
Date: 2008/08/20 04:20
|
By: Canuck
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 17 | |
|
|
After several hours of reading these forums, and the readme, I am still at a loss of what to do. Tried all kinds of weird alterations getting equally weird results.
I was wondering, if I could just un-install the current version, drop the jos_uddeim table, and install a fresh copy of the newest version?
|
|
|
The administrator has disabled public write access. |
|
|
