The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Gazette

Geek Gazette GAZ is a community newsletter management system.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2007, 02:51 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
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 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
Reply With Quote
  #2  
Old 04-06-2007, 07:17 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 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
Reply With Quote
  #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
  #4  
Old 04-07-2007, 12:20 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
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

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?
Reply With Quote
  #5  
Old 04-10-2007, 10: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 02:48 AM..
Reply With Quote
  #6  
Old 04-11-2007, 01:40 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

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
GAZ RC3b Release Discussion The Geek Geek Gazette 10 05-25-2007 03:37 PM
GAZ Private RC 2 Release Discussion The Geek Geek Gazette 0 05-11-2007 10:29 AM
GAZ Private RC 1 Release Discussion The Geek Geek Gazette 12 05-04-2007 10:08 AM
GAZ Private Beta 3 Release Discussion The Geek Geek Gazette 12 04-21-2007 02:22 AM
Beta 3 Release discussion The Geek Geek Article and Review System 20 09-30-2005 12:42 PM


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


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