The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Gazette (http://www.thevbgeek.com/forumdisplay.php?f=56)
-   -   GAZ Private Beta 2 Release Discussion (http://www.thevbgeek.com/showthread.php?t=3051)

The Geek 04-06-2007 01:51 PM

GAZ Private Beta 2 Release Discussion
 
Geek Gazette newsletter manager beta 2 has now been uploaded to the download section for the private beta testing team to download and... er... test :)

Please note the following:

1- You must totally uninstall the previous version before installing beta 2.
2- You can ditch the external cron job from beta 1... I have included it as a vB cron as Kirby feels this should be fine.
3- Read the readme for latest changes
4- Report bugs in the tracker
5- Discuss features/changes in this forum (not this thread).
6- Discuss the release in general in this thread
7- If there is no word from you as a tester within 7 days, I will assume you have bailed out of the testing team and will replace you (there is a hefty line of people waiting to take your place :) )

Still to do:

1- A mail class wrapper to be more versatile (i.e. use SMTP and possibly other MIME types). Currently, the system is only using PHP's mail function
2- Some phrasing
3- Finish phpDocing functions
4- Ensure vb coding standards
5- Usergroup restrictions on newsletter.php browser

Tigratrus 04-06-2007 06:17 PM

Yay!
 
I've got it downloaded, will install it tonight and let Susan have a whack at it.
I'd do it now, but we just got linked by Apartment Therapy Chicago, and it's a *tad* to busy to be doing anything that might even possibly upset the system.;).

Have to say, we're really excited about the potential of GAZ. You've got another winner Geek!

James and Susan

Lizard King 04-06-2007 09:50 PM

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


The Geek 04-06-2007 11:20 PM

Thats odd, if the previous version was totally removed and the new one installed... then it should have created a default newsletter and module set for you. You also wouldnt of had an old published newsletter as it would have been removed during the uninstallation. Are you sure it was fully uninstalled?

Tigratrus 04-10-2007 09:47 PM

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

Tigratrus 04-11-2007 12:40 AM

Just as clarification, we did do a full uninstall and all files were deleted from the server before we installed beta 2.

James and Susan


All times are GMT. The time now is 02:59 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.