I had installed version 1.6 and had upgraded to 1.7.12. This is working fine without any errors or error logs. But on taking backup of the database and trying to install the same at a different place, it is showing #1064 errorHere is the error which I get - #1064 - 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 '<!-- PMA-SQL-ERROR -->    <div class="error"><h1>Error</h1><p><strong>SQL quer' at line 1 I do not want to upgrade further to 1.8 and 1.9 because they have bugs in them like duplicate attachments with gmail etc.My  Php version is 5.4.35 , Mysql version is 5.5.40 , Operating system is Windows 7Please help.

Instead of trying to install it in a different place I would recommend to easily copy over the osTicket directory and also backup & restore the database at the new server - there is no re-installation needed.Just make sure to change the helpdesk URL under Admin Panel > settings after you moved to the new machine.

Yes, different place means other server. I had updated the version 1.6 to 1.7.12 since that had least bugs. After updating, I took back up of the updated folder and updated database.But when I tried to transfer the same to another server, it is giving #1064 error. So, I had to upload the back up of the version 1.6 first and then update it to 1.7.12 in the new server also.Means, I cannot take backup of version 1.7.12 and restore it if needed.Seriously, such a good software like Osticket but the developers must work on backup, updating and restoration which can be done by non-experts..

"I had updated the version 1.6 to 1.7.12 since that had least bugs."I'm not sure how you came to the determination that 1.7.12 had the least bugs... But it is a almost end of life version of the product."But when I tried to transfer the same to another server, it is giving #1064 error. So, I had to upload the back up of the version 1.6 first and then update it to 1.7.12 in the new server also."You did not have to upload the back up and then update it to 1.7.12.  You apparently chose to do so."Means, I cannot take backup of version 1.7.12 and restore it if needed."I have no idea why you would think that is true.  Because it is not."Seriously, such a good software like Osticket but the developers must work on backup, updating and restoration which can be done by non-experts.."Backups and restoration are handled by MySQL.  The same is true of many PHP/MySQL applications. Backups and restores can he done for ANY MySQL/PHP application in this fashion.Updating is handled quite nicely using the upgrader in the application.Would you please explain why it is that you think other wise?

I had said "I had updated the version 1.6 to 1.7.12 since that had least bugs."Ntozier you said "I'm not sure how you came to the determination that 1.7.12 had the least bugs... But it is a almost end of life version of the product."Ntozier, Please see my posts where I have shown issues and bugs in versions 1.8 and above. These are not present in version 1.7.12 - http://forum.osticket.com/d/discussion//why-tickets-are-having-duplicate-attachments#latestI said "But when I tried to transfer the same to another server, it is giving #1064 error. So, I had to upload the back up of the version 1.6 first and then update it to 1.7.12 in the new server also."Ntozier said "You did not have to upload the back up and then update it to 1.7.12.  You apparently chose to do so."No. As said previously, I had tried to directly take backup of 1.7.12 files and database but then got #1064 error on trying to insert the backuped database, so there is no other option left other than to first restore to 1.6 version and then update to higher versions. I have already given all details

I said "Seriously, such a good software like Osticket but the developers must work on backup, updating and restoration which can be done by non-experts.."Ntozier said "Backups and restoration are handled by MySQL.  The same is true of many PHP/MySQL applications. Backups and restores can he done for ANY MySQL/PHP application in this fashion.Updating is handled quite nicely using the upgrader in the application.Would you please explain why it is that you think other wise?"I have already reported these issues in the ticket versions. You can ignore them if you wish or forward it to the Osticket team for further examination and solution.Also, you can compare to other softwares like Wordpress where upgrading, backup and restore is much much easier and hassle free. Here, you have to do things manually at first and are unable to even restore the backuped database. Osticket has a long way to go yet.

You are of course entitled to your opinions.But the only one that I will agree with so far is "osTicket has a long way to go yet".  This statement is very true, but not for the reasons that you appear to be citing.  I'd also point out that Wordpress handles back up and restores via 3rd party plugin which really has nothing to do with Wordpress core product. Additionally osTicket is not a CMS so comparing it to one is like comparing apples to mangos.I get that your experiencing issues and that is frustrating.  I would help you if I could.  So far you are the only person that has reported having those issues.  I have not experienced the problems that you are indicating and I have setup, moved, migrated, upgraded, hacked, broken on purpose, restored, backed up 100s of times at this point. I can only presume at this point that the issues that you are having are something unique to your setup.If MySQL is reporting a syntax error with your backup then there is either an issue with the backup, or there could be a bug your version of MySQL.  Are you moving from to the same version of MySQL?

I have given screenshots and details of the particular issues I am having, Ntozier. Did you try to replicate those ? For example, the issue of the duplicate mails with Gmail was tried by me on different PCs with the same result. I have given the link in my previous comment and screenshots were also given.So, it is not something unique to my setup but can be replicated. Why is it giving two keys ?Why cannot Osticket have a setup, plugin or non-plugin for upgrading without having to upload files. First, I have to download the files, then upload the files. Why we cannot have setup to directly download and overwrite and upgrade ? The direct route leaves lesser scopes for errors.You said "If MySQL is reporting a syntax error with your backup then there is either an issue with the backup, or there could be a bug your version of MySQL.  Are you moving from to the same version of MySQL?"If there is a bug in my version of Mysql, then why there is no problem in uploading first the version 1.6 and then upgrading to 1.7.12. Why there is only problem in uploading of 1.7.12 database and not uploading database of version 1.6 ? Leaving issues unattended and ignoring them could lead to those issues magnifying in future and causing more problems.

Q: Why we cannot have setup to directly download and overwrite and upgrade ?A: I think that the devs plan to add something like that, but its not real high on the priority list right now, and is intrinsically insecure.and hard to make secure. Q: Did you try to replicate those ?A: If you are asking if I tried to open tickets via gmail yes.  It did not result in multiple attachments.  If you are referring to something about 1.7 then no, as I do not have a 1.7 installation.Q: If

there is a bug in my version of Mysql, then why there is no problem in

uploading first the version 1.6 and then upgrading to 1.7.12. Why there

is only problem in uploading of 1.7.12 database and not uploading

database of version 1.6 ?A: First of all this was a guess. 1.6 is a substantially different database structure from 1.7.  It's your version of MySQL that's creating the back up(s), and performing

the restore(s).    Your install is writing the .sql file.  Its then

reading that file that it wrote... and is throwing an error.  You did not answer my question: Are you moving from to the same version of MySQL? "Leaving issues unattended and ignoring them could leave to those issues magnifying in future and causing more problems."No one has said nor implied otherwise.

Regarding the duplicate attachments with tickets in Gmail, I have tested on different servers and using different methods. I was able to replicate issue when installing fresh 1.9.5.1 I was able to replicate the issue after upgrading from older versions to versions 1.8 and above.I was able to replicate the issue with different servers even using test servers.Your not getting any error of duplicate attachments in your setup could also be due to uniqueness of your setup, Or did you test in several setups ?You asked "Are you moving from to the same version of MySQL"While testing, I did test on the same server and in different server with different MySQL."Q: Why we cannot have setup to directly download and overwrite and upgrade ?A: I think that the devs plan to add something like that, but its not real high on the priority list right now, and is intrinsically insecure.and hard to make secure. "Is this directly from the developer or you are presuming ?

As a side note...If you would like to provide ideas,feedback,suggestions I would recommend that you start a separate thread in that part of the forums and divorce the commentary from your trouble thread. We like constructive criticism.

I have given all details of the issue being faced, how to replicate it, what is non-constructive about it, I fail to understand.

"Is this directly from the developer or you are presuming ?"It has been discussed."I have given all details of the issue being faced, how to replicate it,

what is non-constructive about it, I fail to understand."*sigh* no one said you were non-constructive.  I was simply pointing out that conversations like how other programs handle backups/restores and suggesting that osTicket should handle it that same way belongs in a feedback thread, not buried in a troubleshooting thread.

Ok. I will start a separate thread for suggestions. But what about the issues I have described here, any trouble shooting help by anyone or only presumptions ?

You have reported your issues here.You have reported your issues on github.If you are not satisfied with the results of community based support then I can only recommend:http://osticket.com/commercial-support

If admins and developers do not respond to my queries here and only do presumptions, why will I take commercial support or why will I recommend others to do the same ?

YGWYPF."You get what you pay for."TASTAAFL"There ain't no such thing as a free lunch"

Is suggestions now allowed in this thread or only you can do them and not me ? "Test the waters before going deep""There is free trial"Sorry, I would not dream of getting such a poor commercial support.By the way, I am taking screenshot of this thread to show to all for their comments as well.

Q: Is suggestions now allowed in this thread or only you can do them and not me ? A: You can make your suggestions in your thread if you want to, but the likely hood of anyone seeing them and making changes based on your suggestions is miniscule in the wrong section.This forum is not commercial support.I am not commercial support.This is community based support forum.

I see only 2 persons responding here, how is that community support ? I would leave it now to the outside. other communities to decide about the things rather than just presumptions.I have taken screenshot of the thread to show to others, you can do the same.