The vB Geek

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

Geek Gazette GAZ is a community newsletter management system.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 04-12-2007, 03:48 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 3 Release Discussion

This release is for the private beta testing team and is primarily aimed at addressing orphaned subscription field database errors from beta 2.

To install, please make sure you totally uninstall beta 2.

If at any time you get a database error for a missing field, run the synchronise subscription fields tool. That will ensure you have no orphaned subscription fields which was causing the previous error.

Please note that this is a private beta and contains known issues. The primary known issues are:

1- Usergroup permissions for browsing old newsletters and sending old newsletters to friends via email is not in place yet.
2- The issue browser does not yet support browsing and emailing old issues to friends if the users browser doesn't support Ajax.
3- There are some phrases that still need to be completed

Note that for testing purposes, I have included some additional settings for you to fill out in your gaz admincp window. These settings will allow you to have the system go through the motion of sending out emails without actually sending anything out. You can specify a directory to write the emails to instead of sending them out. This will allow you to test everything without actually sending an email. I would encourage you to use this facility.

As ever, report bugs in the tracker. If I don't have word from you within the next 7 days, I will assume you are off the testing team

Thanks!
Reply With Quote
  #2  
Old 04-12-2007, 06:41 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 
Thumbs up Downloaded

Will try to get it installed and give it a spin today/tonight...

James and Susan
Reply With Quote
  #3  
Old 04-16-2007, 02:41 AM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

Well, I'll be right back. my feedback is coming up.

Thank you
Reply With Quote
  #4  
Old 04-16-2007, 03: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
  #5  
Old 04-16-2007, 08:59 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

Try to set the modules 'hot topics only' to no. Looks like that is causing the problem
Reply With Quote
  #6  
Old 04-17-2007, 07:59 AM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

It works fine for me but:
1- module set id doesn't show up.
2- in gmail the sender was like this
Quote:
=?utf-8?B?2KfZhNmF2YTYqtmC2Ykg2KfZhNi32KjZiiDYp9mE2LPZiN ix2YogQmV0YSBHZWVrIEdhemV0dGUgPGluZm9Ac3lyaWFubWVk cy5uZXQ+?=
in outlook (hotmail it was good)
Reply With Quote
  #7  
Old 04-17-2007, 07:53 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 Thanks Geek!

That did it - that would be a useful feature if it can be fixed.

Ok...today's list:
  • In the Issue>Data>Refresh Layout or Generate New Data, I still see the text:

    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)

    And the same only doubled (i.e. the above list twice) when in Issue>Reset Data
  • The times and dates are screwy. For instance in the 'You last visited' the time reads 'Apr 17th, 2007 3:30 at' instead of 'Apr 17th, 2007 at 1:30' Note both the misplaced 'at' and the time difference. Perhaps I'm just missing a variable or two that need to escape? Is there a variable I need to include to make the time zone match the recipient's time zone?I'm still learning about variables.

    Also, related: In my thread modules, the date is listed as 'Tuesday the 10th of 2007' instead of the expected 'Apr 17th, 2007, 1:30 pm'.
  • How difficult would it be to create a photo module? Preferably one that could either pull the most recently uploaded photos or a selected group of photos. We're using PhotoPlog, but I would have not a clue where to start to create such a thing. I imagine a photo module would be beneficial to many.
  • Tools>Synchronize Subscription Fields>Database error:
    Code:
    Database error in vBulletin 3.6.5:
    
    Invalid SQL:
    SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'gaz_subscriptions' AND table_schema='****_vbulletin';
    
    MySQL Error  : SELECT command denied to user '****_admin'@'localhost' for table 'columns'
    Error Number : 1142
    Date         : Tuesday, April 17th 2007 @ 03:55:12 PM
    Script       : http://www.****.biz/forums/admincp/gaz_admin.php?do=syncsubfields
    Referrer     : http://www.***.biz/forums/admincp/gaz_admin.php?do=tools
    IP Address   : 70.104.***.***
    Username     : Susan
    Classname    : vb_database
    FYI: We moved our testing over to a test server - sql permissions may not be set correctly - investigating now.
  • Is there way to set the max character number for previews on thread modules? I really need this or the preview function is almost useless to me.
  • Also would be nice to be able to select specific threads to include in a thread module a la the vBAdvanced CMPS News Module.

That's all for now.

For the record, I'm using Windows XP and Firefox 1.5.0.11 as well as Internet Explorer 6.0SP2 for testing.

Susan and James
Reply With Quote
  #8  
Old 04-17-2007, 08:41 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

Thanks guys.

A couple of questions:

@Milad: Where does the module set id not show up? If you could pm me the entire header of the suspect emial, it would help too!

@Tig:
1- What youre seeing there is verbose output while GAZ builds a snapshot of the newsletter for each style and each language. That is by design though I may gussy it up somewhat
2- Make sure that lands in the tracker please
3- Additional modules will be (relativly) easy to make though I think I will create a poll and/or gars one before I build a gallery one. Maybe we can jazz up some users to make some?
4- That is a SQL premissions error. Check them out as it looks like youre restricted?
5- IIRC its currently hard coded, but will be a setting soon
6- Hmmmm.... Do you mean a simple setting that accepts a comma seperated list of threadids?

Thanks for your time guys
Reply With Quote
  #9  
Old 04-18-2007, 03:59 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

  • Aha!
  • Will do when done here
  • GARS one would be cool. Gallery would be top of my list, but I understand you've got to do what's most desirable to the masses. Wish I knew enough to create one. Lizard King?
  • Yep. SQL. Yep.
  • Great!
  • That would work, although I was thinking of CMPS's Edit Threads where you choose a forum, then the list of threads comes up and you select and submit one or more for inclusion. You don't have to find threadids - it's pretty idiot proof.

Thank YOU!
Reply With Quote
  #10  
Old 04-18-2007, 08:39 AM
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

I can try to throw out a gallery module for vbgallery also i am planning to have a vblogetin module but the problem is i am so busy these days. I can hardly find time to surf around. At least i can start that in 10 days.
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 2 Release Discussion The Geek Geek Gazette 5 04-11-2007 01:40 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 04:00 AM.


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