View Single Post
  #5  
Old 04-10-2007, 09:47 PM
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

Newsletters> Start Date>Reverts to today's date

Newsletters>Generate New Issue>Error Message:

Warning: Missing argument 1 for GAZ_class_cron::GAZ_class_cron(), called in /home/****/public_html/forums/geek/ gaz /includes/gaz_admin_functions.php on line 44 and defined in /geek/gaz/includes/gaz_class_cron.php on line 23

Newsletters>Add New>Generate Issue>Error message
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 (22) 
        ORDER BY thread.replycount DESC 
        LIMIT 3;

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 (22) 
        ORDER BY thread.replyco' at line 13
Error Number : 1064
Date         : Tuesday, April 10th 2007 @ 04:52:12 PM
Script       : http://www.****.com/forums/admincp/gaz_admin.php?do=refreshissue
Referrer     : http://www.****.com/forums/admincp/gaz_admin.php?do=refreshissue&id=1
IP Address   : 72.82.**.**
Username     : Susan
Classname    : vB_Database
After above error occurs, no issue is created. Second try on Generate Issue results in same error, but then issue is available in Navigator/Issues

Issues>Generate New Data>Error Message>

Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

            SELECT count(u.userid) total
            FROM user u
            INNER JOIN gaz_subscriptions s ON (u.userid = s.userid)
                WHERE s.newsletter2=1   AND (u.usergroupid IN (6)  OR FIND_IN_SET('6', u.membergroupids))  AND (u.options & 16) 
            ORDER BY u.userid ASC;

MySQL Error  : Unknown column 's.newsletter2' in 'where clause'
Error Number : 1054
Date         : Tuesday, April 10th 2007 @ 05:44:10 PM
Script       : http://www.****.com/forums/admincp/gaz_admin.php?do=saveissue
Referrer     : http://www.****.com/forums/admincp/gaz_admin.php?do=editissue&id=6
IP Address   : 72.82.**.**
Username     : Susan
Classname    : vB_Database
Issues>Preview HTML>Brings up preview of modules that aren't mine - Module on left/center is Info, Module on right is Stats -I don't have either on my module set enabled.

Navigator>Options>Refresh Layout>Brings up confirmation for Reset Sent Counter.

When a new member is registering we're getting:

Code:
Database error in vBulletin 3.6.5:

Invalid SQL:
INSERT INTO gaz_subscriptions (userid, emailformat , newsletter1, newsletter2) VALUES (11706, 1 , 1, 1);

MySQL Error  : Unknown column 'newsletter2' in 'field list'
Error Number : 1054
Date         : Tuesday, April 10th 2007 @ 07:56:54 PM
Script       : http://www.****.com/forums/register.php?do=addmember
Referrer     : http://www.****.com/forums/register.php?do=register
IP Address   : 68.81.***.***
Username     : ****
Classname    : vB_Database
The registration seems to complete fine, but we are generating the error each time.

Susan and James

Last edited by Tigratrus; 04-11-2007 at 01:48 AM..
Reply With Quote