Upgrade from 1.6 RC4 to RC5 Help!

[relievemypc]

So I uploaded all the new files to the directory preserving the same file structure as before. When logging into my admin panel I see the message on the top that says:

"The script is version 1.6 RC5 while the database is version 1.6 RC4. Possibly caused by incomplete upgrade."

I attempted to go to the setup/upgrade.php location to upgrade however i'm directed to a blank page with nothing on it. Any help will be much appreciated!

[peter]

Can you check your apache logs for php errors? If not follow the instructions below to make it display on the page.

In main.inc.php find

PHP Code:

ini_set('display_errors',0);
ini_set('display_startup_errors',0); 


and change it to

PHP Code:

ini_set('display_errors',1);
ini_set('display_startup_errors',1); 


[relievemypc]

Appreciate the response...To elaborate a little more. I received over 30+ emails with the title DB Error #1054 and unfortunately I cannot view the tickets that are outstanding in the ticket queue that were there previously. Luckily I backed up everything and just reloaded the previous version so it is now up and running. I just don't have the updated version

Examples of these errors below:

Email 1:
[SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,t icket.staff_id,subject,name,email,dept_name ,ticket.status,ticket.source,isoverdue,isanswered, ticket.created,pri.* ,count(attach.attach_id) as attachments FROM relievem_ticket ticket LEFT JOIN relievem_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN relievem_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN relievem_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() LEFT JOIN relievem_ticket_attachment attach ON ticket.ticket_id=attach.ticket_id WHERE 1 AND status='closed' GROUP BY ticket.ticket_id ORDER BY ticket.closed DESC, ticket.created DESC LIMIT 0,50]

Unknown column 'isanswered' in 'field list'


Email2:
[SELECT count(open.ticket_id) as open, count(answered.ticket_id) as answered ,count(overdue.ticket_id) as overdue, count(assigned.ticket_id) as assigned FROM relievem_ticket ticket LEFT JOIN relievem_ticket open ON open.ticket_id=ticket.ticket_id AND open.status='Open' AND open.isanswered=0 LEFT JOIN relievem_ticket answered ON answered.ticket_id=ticket.ticket_id AND answered.status='Open' AND answered.isanswered=1 LEFT JOIN relievem_ticket overdue ON overdue.ticket_id=ticket.ticket_id AND overdue.status='Open' AND overdue.isoverdue=1 LEFT JOIN relievem_ticket assigned ON assigned.ticket_id=ticket.ticket_id AND assigned.staff_id=1]

Unknown column 'open.isanswered' in 'on clause'

Email3:
[SELECT DISTINCT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,t icket.staff_id,subject,name,email,dept_name ,ticket.status,ticket.source,isoverdue,isanswered, ticket.created,pri.* ,count(attach.attach_id) as attachments FROM relievem_ticket ticket LEFT JOIN relievem_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN relievem_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN relievem_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() LEFT JOIN relievem_ticket_attachment attach ON ticket.ticket_id=attach.ticket_id WHERE 1 AND status='open' AND isanswered=0 GROUP BY ticket.ticket_id ORDER BY priority_urgency,ticket.created DESC LIMIT 0,50]

Unknown column 'isanswered' in 'field list'


ect ect. I can attach more you like.

[peter]

Above errors are expected if you access staff control panel before the upgrade is completed. The error(s) I was referring to are what you get on the upgrade page.

[relievemypc]

There are no errors on the upgrade page. I just get a blank page basically.

[Corey]

Originally Posted by relievemypc

There are no errors on the upgrade page. I just get a blank page basically.

Hey,

You get a blank page even with error reporting turned on?

What version of MySQL do you have osTicket installed on?
What version of PHP do you have osTicket installed on?
What OS (Windows, Linux) do you have osTicket installed on?

[relievemypc]

Not sure if error reporting is turned on. Where can I find the output file for this?

Apache version 2.2.11 (Unix)
PHP version 4.4.9
MySQL version 5.0.75
Architecture x86_64
Operating system Linux

I think its important to note that the previous directory structure was altered so the files are no longer in the upload folder but in the root directory. This seems to have caused problems in the past. Do you think this could be a source of the issue I am experiencing?

[Corey]

Originally Posted by relievemypc

Not sure if error reporting is turned on. Where can I find the output file for this?

Hey,

Read the second post by Peter in this thread.

[relievemypc]

Not sure what i did but i re downloaded the new version and uploaded the files and bingo. All set! I've been playing around with the release and I'm very pleased with the new features. Very nice job! Thank you for your assistance.