View Single Post
  #4  
Old 04-16-2007, 02:11 AM
Tigratrus's Avatar
Tigratrus Tigratrus is offline
Senior Member
 
Join Date: Nov 2006
Posts: 206
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

  • Newsletter Page>Generate New Issue

    Code:
    Database error in vBulletin 3.6.5:
    
    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.views >= 1000AND thread.replycount >= 50
    			AND thread.forumid in (94) 
    		ORDER BY thread.dateline DESC 
    		LIMIT 1;
    
    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 'thread.replycount >= 50
    			AND thread.forumid in (94) 
    		ORDER BY thread.datelin' at line 13
    Error Number : 1064
    Date         : Sunday, April 15th 2007 @ 09:46:40 PM
    Script       : http://www.****.com/forums/admincp/gaz_admin.php?do=generatenewissue&id=2
    Referrer     : http://www.****.com/forums/admincp/gaz_admin.php?do=displaynewsletters
    IP Address   : 71.253.***.**
    Username     : Susan
    Classname    : vB_Database

  • Issue page>Preview Issue>HTML

    Info and stats modules show up though I haven't selected stats, and it's not using selected module set. Thread modules not showing, simple text blocks not showing.

  • Navigator/Issue page>Reset Data

    Code:
    Database error in vBulletin 3.6.5:
    
    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.views >= 1000AND thread.replycount >= 50
    			AND thread.forumid in (94) 
    		ORDER BY thread.dateline DESC 
    		LIMIT 1;
    
    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 'thread.replycount >= 50
    			AND thread.forumid in (94) 
    		ORDER BY thread.datelin' at line 13
    Error Number : 1064
    Date         : Sunday, April 15th 2007 @ 09:58:58 PM
    Script       : http://www.****/forums/admincp/gaz_admin.php?do=refreshissue
    Referrer     : http://www.****/forums/admincp/gaz_admin.php?do=refreshissue&id=5
    IP Address   : 71.253.***.**
    Username     : Susan
    Classname    : vB_Database
  • Issue page>Generate New Data or Refresh Layout

    This shows:

    1. 1 -
    1. 1 - English (US)
    2. 3 - Default Style
    1. 1 - English (US)
    3. 5 - Articles
    1. 1 - English (US)
    4. 6 - Testing Child of Articles
    1. 1 - English (US)
    5. 7 - Glossary/Directory
    1. 1 - English (US)
    6. 17 - All Articles
    1. 1 - English (US)
    7. 9 - Moderators w/Heckle
    1. 1 - English (US)
    8. 10 - Blog Style
    1. 1 - English (US)
    9. 15 - Home
    1. 1 - English (US)
    10. 16 - Yes. It's IKEA.
    1. 1 - English (US)

    before the expected 'Saved Issue'

    (These are defined styles on our site)

Susan and James
Reply With Quote