Hi everyone,I imported the existing database of OS from the current hosting to a new hosting. While installing, I encountered an error message that says, Prefix is already in-use. On my control panel, I have two databases together. The 2nd database does not have this prefix. I changed the first database's prefix and still get the similar message. I hit F5 and retype the info with all over again. This time I changed the prefix. Nothing work. Please help. Thank you for your time.
By default osTicket uses ost_ as it's prefix. If you used a custom pre-fix you will need to manually edit the /include/ost-config.php file to specifcy the DB credentials and prefix. You should not be running the installer after importing the DB you should tailor the config to use the existing imported DB then go to the site.
Can you provide me an example if I use a custom pre-fix, which line do I edit the file?# Table prefixdefine('TABLE_PREFIX','%CONFIG-PREFIX');Thanks!
The line that you just added to your post.
That's it. Thanks so much!
It says I installed this successfully. Just curious, as 4, it show an interface with this big text. Support Ticket System Offline
It appears that you have the system in offline mode and are going to the User side.To change it you would go to the admin side and log in as an admin.hint: add /scp to the URL that you are going to.
Good morning Ntozier,I put the scp to the URL and it brings me to a new page with this message, "Valid CSRF Token Required".I don't have a token.So what do I do next?
Clear your browser cache and cookies. And try again.The CSRF token is part of the login page and send from the server to ensure that the login attempt is a. recent and b. came from the server.
I cleaned up my cache. I still get that message. Also, I tried Chrome and Firefox without any success. What's next?
No ideas other than:Do a fresh installation.Restore your old DB over the new one.Alternatively you could invest in Professional Installation or Commercial Support.
Now we are moving to a new hosting and downloaded the latest version here. This is my second time to install OS. Thought I was an expert, I will try to install again. Thanks for your time. Keep you posted soon.
This is still bugging. We never figure the answer out. What triggered this message at the beginning. We have a problem - another installation with same table prefix exists!I have installed the DB first, then OS. If OS picked up the table prefix from this DB, then this popups up my mind, in t theory, I should install the DB last, therefore OS will never pick this up. Right? Then my problem is solved, I think so.
You haven't included any environment information about your old host, or your new host. You should install osTicket first, .let it create a new empty DB, then as @[deleted] said, restore your old DB over the new one.
Hey thereI am back :-)Follow what you said, this time I installed the latest version successfully. Told my coworker to sign in and he got an access denied message. 1. Is it possible to have two OS running and received this message?Thanks!
Did you copy your /include/ost-config.php from the old server to the new server?Or did you edit the new one? If you edited the new one, copy the old one.I really think that you need to start over. Drop both databases and delete the dbuser. remove both installations.Create a new database (with the same name as the old one on the old server).Create a new dbuser (with the same name as the old on on the old server).Give the DB user privs on the new DB.Import the database from the old server.Install the code from the archive.copy the /include/ost-config.php from the old server and put it on the new.Browse to the site on the new server.
I started over with a new installation, given user privs and renamed DB with the new name and new user. Lastly, I didn't copy the old os-config file from the over server and put it on the new oneCreate a new database (with the same name as the old one on the old server).I will definitely do this one nextCreate a new dbuser (with the same name as the old on on the old server). I will definitely do this one nextGive the DB user privs on the new DB.Import the database from the old server.Install the code from the archive What do you mean archive? copy the /include/ost-config.php from the old server and put it on the new. I will definitely do this one nextBrowse to the site on the new server.
Q: Install the code from the archive What do you mean archive? A: the archive that you downloaded from osticket.com/download. Copy the files from the upload folder and put it where you want them on your server.
I imported the old database and get this message. What does this mean?Error
SQL query:
---- Dumping data for table `ost_api_key`-- INSERT INTO `ost_api_key` ( `id` , `isactive` , `ipaddr` , `apikey` , `updated` , `created` ) VALUES ( 1, 1, '192.168.1.5', 'siri!', '2013-01-11 12', '2013-01-11 12' ) ;
MySQL said:
#1062 - Duplicate entry '1' for key 'PRIMARY'
I know most previous contact detail didn't import so I am guessing something is missing under Ost_API_key. Was it table?
