Tickets Membership Database (Tickets MDB)

203 views
Skip to first unread message

AndyH

unread,
Sep 14, 2012, 6:40:35 PM9/14/12
to open-so...@googlegroups.com
All.
 
After a few unavoidable delays in getting it to a release product I am now pleased to announce the availability of Tickets MDB Version 1.0B. Also available with this is a manual giving installation instructions and the most common operating instructions. The manual will develop over time as users become familiar with the application and it's use.
 
key points
  • Installation of Tickets MDB is as per normal Tickets installation (however it is a stand alone product and doesn't require Tickets to function but can be connected by the soon to be released Tickets PDB Integration Module), i.e. create a database, unzip the release zip file, upload the contents to a folder on a web server and point a browser at that location - you will be taken to a page with a link to install if it is a fresh installation.
  • The Install routine checks that your server meets the required minimum specification.
  • A lot of the settings and the process for changing them are the same as Tickets - it may just look a bit different.
  • Tickets MDB uses Open Street Map rather than Google Maps and can have map tiles downloaded onto the server / PC / Laptop making it a fully self contained product, not requiring network connectivity to work apart from email.
  • Tickets MDB functions under the key browsers however there maybe some slight differences between how things look (not service affecting) between Internet Explorer and Firefox due to the way Firefox handles CSS styling.
  • You can store ID Pictures and Members specific files such as scans of training certificates in the file structure and view from the application.
Post up any issues that you have with installing or running the product on this group as usual and I will work through resolutions for any code issues. The product has been through a limited release Alpha testing process so I am reasonably confident that the major issues have been ironed out - but after all if things can go wrong then they most probably will.
 
There are elements within Tickets MDB designed to help migration from the typical small operation Membership Database based on a spread sheet - I know about these things, I am in one of the voluntary groups myself and we did start with spread sheets. The main element is the ability to upload .csv files into the database with the important elements of the database - member lists, equipment lists, clothing lists, training packages. There is also then an ability within the configuration page that allows an admin to bulk allocate train / equipment etc to multiple members in one go rather than having to edit individual member data.
 
As with any new application please be careful and don't put into a live environment before you are happy that it operates as you want it to - also take regular backups - important with any operational or personnel data.
 
One final point, as the data stored on the system will be personal, please be aware of your own locality / country data protection requirements and while Tickets MDB is built along the same secure login platform as Tickets CAD, it is sensible to put the data behind a firewall or behind HTTP authorisation using .htaccess files.
 
One final point, Tickets MDB would not have been possible without the work that Arnie put into Tickets CAD in the first place and while the concept and execution of Tickets MDB is down to me, at least 50% of the code is Tickets CAD and as such much Kudos should go to Arnie.
 
The files are available on Sourceforge here.
 
Tickets MDB will be enhanced over time and as with Tickets CAD it will be upgradeable and backwards compatible.
 
Andy Harvey - Sept 2012.
 
 

Ross

unread,
Sep 15, 2012, 4:16:36 PM9/15/12
to open-so...@googlegroups.com
Have had this error after a fresh install

Parse error: syntax error, unexpected $end in /home/sussex4x/public_html/ticketsdb/index.php on line 374 

Hmmm?? a little help would be appreciated, thanks all.

Ross

 
 

--
You received this message because you are subscribed to the Google Groups "Open Source CAD" group.
To view this discussion on the web visit https://groups.google.com/d/msg/open-source-cad/-/MSZkFGo_UTMJ.
To post to this group, send email to open-so...@googlegroups.com.
To unsubscribe from this group, send email to open-source-c...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/open-source-cad?hl=en.

Andy Harvey

unread,
Sep 15, 2012, 6:28:15 PM9/15/12
to open-so...@googlegroups.com

Ross.

 

Sorry, my fault.

 

The enclosed fixes it.

 

Cheers
Andy

index.php

AndyH

unread,
Sep 15, 2012, 6:30:56 PM9/15/12
to open-so...@googlegroups.com
All.
 
Sorry about this, schoolboy error in index.php. The enclosed fixes it.
 
I'll get a revised zip uploaded to replace the faulty one but just copy the enclosed over the existing index.php in the Tickets MDB root directory.
 
Cheers
AndyH
index.php

Arnie Shore

unread,
Sep 15, 2012, 6:41:25 PM9/15/12
to open-so...@googlegroups.com
Andy, upload done.

A

On 9/15/12, AndyH <harve...@hotmail.com> wrote:
> All.
>
> Sorry about this, schoolboy error in index.php. The enclosed fixes it.
>
> I'll get a revised zip uploaded to replace the faulty one but just copy the
>
> enclosed over the existing index.php in the Tickets MDB root directory.
>
> Cheers
> AndyH
>
> On Friday, September 14, 2012 11:40:35 PM UTC+1, AndyH wrote:
>
>> All.
>>
>> After a few unavoidable delays in getting it to a release product I am now
>>
>> pleased to announce the availability of Tickets MDB Version 1.0B. Also
>> available with this is a manual giving installation instructions and the
>> most common operating instructions. The manual will develop over time as
>> users become familiar with the application and it's use.
>>
>> key points
>>
>> - Installation of Tickets MDB is as per normal Tickets installation
>> (however it is a stand alone product and doesn't require Tickets to
>> function but can be connected by the soon to be released Tickets PDB
>> Integration Module), i.e. create a database, unzip the release zip
>> file,
>> upload the contents to a folder on a web server and point a browser at
>> that
>> location - you will be taken to a page with a link to install if it is
>> a
>> fresh installation.
>> - The Install routine checks that your server meets the required
>> minimum specification.
>> - A lot of the settings and the process for changing them are the same
>>
>> as Tickets - it may just look a bit different.
>> - Tickets MDB uses Open Street Map rather than Google Maps and can
>> have map tiles downloaded onto the server / PC / Laptop making it a
>> fully
>> self contained product, not requiring network connectivity to work
>> apart
>> from email.
>> - Tickets MDB functions under the key browsers however there maybe
>> some slight differences between how things look (not service affecting)
>>
>> between Internet Explorer and Firefox due to the way Firefox handles
>> CSS
>> styling.
>> - You can store ID Pictures and Members specific files such as scans
>> here<https://sourceforge.net/projects/openises/files/MDB/>
>> .
>>
>> Tickets MDB will be enhanced over time and as with Tickets CAD it will be
>>
>> upgradeable and backwards compatible.
>>
>> Andy Harvey - Sept 2012.
>>
>>
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Open Source CAD" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/open-source-cad/-/KeXBvQLhzxYJ.

James

unread,
Sep 15, 2012, 11:04:48 PM9/15/12
to open-so...@googlegroups.com
I believe the member.php is missing. I can't add members.

Richard Condie

unread,
Sep 15, 2012, 11:14:03 PM9/15/12
to open-so...@googlegroups.com
Hi All 

Found this problems
1. date format will not change to DD/MM/YYYY
2. this error comes up in add member and also memberlist. 

Object not found!

The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.

If you think this is a server error, please contact the webmaster.

Error 404

localhost
Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4

also the state is 2 digit and will not change to 3 in local settings

Many thanks 
RichardC

Ross

unread,
Sep 16, 2012, 1:28:09 AM9/16/12
to open-so...@googlegroups.com
Yup, member.php is missing lol.

AndyH

unread,
Sep 16, 2012, 4:18:42 AM9/16/12
to open-so...@googlegroups.com
All.
 
OK some extra problems have surfaced. missing member.php (goes in the root Tickets MDB directory) enclosed, however look for an updated zip with the state field length sorted and any other errors sorted in the next day or so.
 
Cheers
Andy

On Friday, September 14, 2012 11:40:35 PM UTC+1, AndyH wrote:
member.php

Andy Harvey

unread,
Sep 16, 2012, 4:27:58 AM9/16/12
to open-so...@googlegroups.com

Richard.

 

What locale setting have you got in the config settings, should be 1 or 2 (1 for UK, 2 for ROW, both show DD/MM/YYYY in both add member and the memberlist on mine. Yours should be ROW but try the UK setting just to be sure.

 

Cheers
Andy

 


Sent: 16 September 2012 06:28
To: open-so...@googlegroups.com

Richard Condie

unread,
Sep 16, 2012, 4:50:23 AM9/16/12
to open-so...@googlegroups.com
Changed locale 2 to and it seems to be ok now but the member.php seems to be doing nothing. 
member types does not submit. and i get the same error as about for the member list and members.

RichardC

Richard Condie

unread,
Sep 16, 2012, 4:59:40 AM9/16/12
to open-so...@googlegroups.com
Hi 
Further to my last post i have looked at member.php and the field nanes are field 2 and so on is this correct

Richardc

Ross

unread,
Sep 16, 2012, 9:08:51 AM9/16/12
to open-so...@googlegroups.com
The field names arn't names in the member table due to the way it is built. all other tables have specific headings though.

AndyH

unread,
Sep 16, 2012, 11:04:23 AM9/16/12
to open-so...@googlegroups.com
Richard.

Sorry about this. Found the problem with submission of member types. You need to upload the enclosed tables.php into the tickets mdb root folder and the enclosed c_member_types.php into the tables sub folder.

When you say member.php doesn't do anything, what do you mean here - can you display a member details from clicking on an entry in the member list, then can you click edit member and edit and then submit the changes?.

Cheers
Andy
tables.php
c_member_types.php

AndyH

unread,
Sep 17, 2012, 5:27:15 AM9/17/12
to open-so...@googlegroups.com
Richard.
 
Yes that is correct, it is how the variable field names is implemented. The actual field names are in the table defined_fields.
 
Cheers
Andy

AndyH

unread,
Sep 17, 2012, 5:28:23 AM9/17/12
to open-so...@googlegroups.com
All.
 
Expect a new zip file to be uploaded very soon - Version 1.1 17/09/12 which fixes the currently identified issues but has no additional functionality.
 
Cheers
AndyH

On Friday, September 14, 2012 11:40:35 PM UTC+1, AndyH wrote:

Ross

unread,
Sep 18, 2012, 5:16:20 AM9/18/12
to open-so...@googlegroups.com
Wonderful, I'll wait before reinstalling My database. Which brings me onto another question, how is the best way to reinstal the database, it's only that I backed all my tables up as one. spl and one csv but it won't re import and also did them seperatly so I could re import them incase the others didn't work and there throwing up errors aswell. When I tried to install the database it failed on writing new table because my old ones were there so I deleted them allowing a fresh install which is what led me onto my imprt problem. many thanks

Ross

--
You received this message because you are subscribed to the Google Groups "Open Source CAD" group.
To view this discussion on the web visit https://groups.google.com/d/msg/open-source-cad/-/4wf1RFds6aUJ.

Ross

unread,
Sep 18, 2012, 9:53:47 AM9/18/12
to open-so...@googlegroups.com
Now I've imported all our details again I've noticed a couple of little things. On the members list screen no matter what list setting it is on 50, 100, 200 etc it only displays one page of people with no ability to scroll down the list, if you set it to 50 or so and try and click next page then it goes and displays an empty page all though i have a full database of members???
When clicking to display a vehicle under a members profile you get a pop out that should display the vehicle at the top and then it details underneath however i get the reg no and make displayed in the greyed out drop down at the top but underneath it displays TBA under every detail, make, model, roof rack etc???

and finally I got this error under the members profile

Driving Licence Expiry: 
Notice: A non well formed numeric value encountered in /home/sussex4x/public_html/ticketsdb/incs/functions.inc.php on line 587

Notice: A non well formed numeric value encountered in /home/sussex4x/public_html/ticketsdb/incs/functions.inc.php on line 588

Notice: A non well formed numeric value encountered in /home/sussex4x/public_html/ticketsdb/incs/functions.inc.php on line 589

AndyH

unread,
Sep 19, 2012, 6:33:12 AM9/19/12
to open-so...@googlegroups.com
Ross.
 
I've emailed you on this - couple of errors in your DB which you have the instructions how to fix to solve the first problem however for everyone else, the latest zip is now uploaded so you need to get hold of that and install but also (will update the zip in the next couple of days if there are no more problems) you need to download the enclosed revised functions.inc.php which goes in the /incs subdirectory which fixes a problem with the automatically generated field controls for dates - only apparent if you are using the extra flexible date fields.
functions.inc.php

Ross

unread,
Sep 20, 2012, 8:33:31 AM9/20/12
to open-so...@googlegroups.com
Getting this notice when in the members profile page


Warning
: array_unique() [function.array-unique]: The argument should be an array in /home/sussex4x/public_html/ticketsdb/member.php on line 1003

Warning: implode() [function.implode]: Invalid arguments passed in /home/sussex4x/public_html/ticketsdb/member.php on line 1003

Notice: Undefined offset: 1 in /home/sussex4x/public_html/ticketsdb/incs/functions_mail.inc.php on line 213 


So far all other fixes have fixed the problems (even if one or 2 were my fault) lol

Thanks
Ross

To view this discussion on the web visit https://groups.google.com/d/msg/open-source-cad/-/Jr64LQMvsJIJ.

Andy Harvey

unread,
Sep 20, 2012, 9:12:42 AM9/20/12
to open-so...@googlegroups.com

Ross.

 

Both these areas are to do with notifying users when something has changed. Do you have any valid email addresses for any of the users?.

 

The code definitely needs changing to reflect cases where there are no email addresses defined but I would just like to know if my hunch is correct and it is that there are no email addresses (it only looks at superadmins at the moment so if there is no email address in for any of your superadmins, put one in and see if the problems go away.

 

Cheers
Andy

 

From: open-so...@googlegroups.com [mailto:open-so...@googlegroups.com] On Behalf Of Ross
Sent: 20 September 2012 13:34
To: open-so...@googlegroups.com
Subject: Re: [Open-Source-CAD] Re: Tickets Membership Database (Tickets MDB)

 

Getting this notice when in the members profile page

Ross

unread,
Sep 20, 2012, 9:25:10 AM9/20/12
to open-so...@googlegroups.com
It complained even more after that but that's because outgoing mail isn't set up yet.
The field length for email addresses was too short for our membe...@sussex4x4response.co.uk addy, might be worth tweaking it for later releases, I've changed it to a longtext box as an interim change, same could be done to the Street field in personel details as where the house name and street name are going in that box it is cutting the end of the address off.

Ross

Andy Harvey

unread,
Sep 20, 2012, 9:57:04 AM9/20/12
to open-so...@googlegroups.com

Ross.

 

OK I’ll have a look at that.

Ross

unread,
Sep 20, 2012, 9:59:42 AM9/20/12
to open-so...@googlegroups.com
Sorry Andy, Another one for you, when trying to send outgoing mail, as far as I can tell our SMTP is correct as a test email from the test SMTP screen worked fine.


Notice: Undefined offset: 1 in /home/sussex4x/public_html/ticketsdb/incs/functions_mail.inc.php on line 155

Notice: Undefined offset: 2 in /home/sussex4x/public_html/ticketsdb/incs/functions_mail.inc.php on line 155

Notice: Undefined offset: 3 in /home/sussex4x/public_html/ticketsdb/incs/functions_mail.inc.php on line 156

Notice: Undefined offset: 4 in /home/sussex4x/public_html/ticketsdb/incs/functions_mail.inc.php on line 157

Fatal error: Uncaught exception 'Swift_RfcComplianceException' with message 'Address in mailbox given [meme...@sussex4x4reposne.co.uk,ro22...@hotmail.com] does not comply with RFC 2822, 3.6.2.' in /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/Headers/MailboxHeader.php:319 Stack trace: #0 /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/Headers/MailboxHeader.php(249): Swift_Mime_Headers_MailboxHeader->_assertValidAddress('memership@susse...') #1 /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/Headers/MailboxHeader.php(107): Swift_Mime_Headers_MailboxHeader->normalizeMailboxes(Array) #2 /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/Headers/MailboxHeader.php(71): Swift_Mime_Headers_MailboxHeader->setNameAddresses(Array) #3 /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/SimpleHeaderFactory.php(74): Swift_Mime_Headers_MailboxHeader->setFieldBodyModel(Array) #4 /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/SimpleHeaderSet.php(87): Swift_Mime_Simple in /home/sussex4x/public_html/ticketsdb/lib/classes/Swift/Mime/Headers/MailboxHeader.php on line 319 
Reply all
Reply to author
Forward
0 new messages