View Single Post
  #3  
Old 04-06-2007, 10:50 PM
Lizard King's Avatar
Lizard King Lizard King is offline
Senior Member
 
Join Date: Oct 2005
Location: Istanbul
Posts: 555
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

Have an issue when creating new newsletter.

For installation process , i uninstalled the previous version and installed the new one. After that created a module set everything went smooth up to now. When adding a new version i get a database error
Code:
Database error in vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE gaz_subscriptions ADD newsletter1 TINYINT NOT NULL;

MySQL Error  : Duplicate column name 'newsletter1'
Error Number : 1060
Date         : Friday, April 6th 2007 @ 05:48:22 PM
Script       : http://www.ayyas.com/admincp/gaz_admin.php?do=savenewsletter
Referrer     : http://www.ayyas.com/admincp/gaz_admin.php?do=editnewsletter
IP Address   : ****
Username     : Lizard King
Classname    : vB_Database
Editing an old published newsletter also have a database error

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

		SELECT 
			thread.threadid, thread.title, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, pollid
			
			,thread.forumid, forum.title AS forumtitle
		FROM thread as thread
		
		LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
		
		
		WHERE open != 10
			AND thread.visible = 1 AND thread.lastpost >= 1175313600
			
			
			
		ORDER BY thread.dateline DESC 
		LIMIT;

MySQL Error  : 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 '' at line 16
Error Number : 1064
Date         : Friday, April 6th 2007 @ 05:53:01 PM
Script       : http://www.ayyas.com/admincp/gaz_admin.php?do=saveissue
Referrer     : http://www.ayyas.com/admincp/gaz_admin.php?do=editissue&id=1
IP Address   :****
Username     : Lizard King
Classname    : vB_Database

Last edited by Lizard King; 04-06-2007 at 10:53 PM..
Reply With Quote