PDA

View Full Version : GAZ Private Beta 2 Release Discussion


The Geek
04-06-2007, 02:51 PM
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, 07:17 PM
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, 10: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
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


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-07-2007, 12:20 AM
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, 10: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
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_DatabaseAfter 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>

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_DatabaseIssues>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:

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, 01: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