mangla_nsit Posted November 3, 2005 Share Posted November 3, 2005 (edited) Im a new customer at TCH and the past 24 hrs have been hell. Apart from the time zone difference, support (via helpdesk tickets) has been very slow and buggy. Ive just realised that my previous webhosts were using version MySql 4.1.13 while you guys at TCH are using MySql 4.0.22 which is incompatible with the IPB forum software that IM using ! Please help me as Ive (stupidly enough) changed DNS info and my site has been down for quite a while now. Im posting at a public forum cause the support system seems to be too clogged or maybe clueless Help ! The main problem Im facing is with respect to timestamps ! >timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, throws up errors when restoring database ! while it appears many times in the backup Edited November 3, 2005 by mangla_nsit Quote Link to comment Share on other sites More sharing options...
Head Guru Posted November 3, 2005 Share Posted November 3, 2005 The support system is not clogged and is for sure not clueless. I am sorry but we do not provide support for the coding of webpages, scripting or 3rd party applications. Hopefully you can get your answer here on the user forums. Quote Link to comment Share on other sites More sharing options...
Deverill Posted November 3, 2005 Share Posted November 3, 2005 Apart from the time zone difference, support (via helpdesk tickets) has been very slow and buggy.Im posting at a public forum cause the support system seems to be too clogged or maybe clueless I doubt the helpdesk techs are clogged or clueless - they are some top class people that are a great help to many daily. The truth of it is that since TCH's techs don't support third party scripts that it has pushed your ticket to a lower priority than other requests they have. I can't speak for them but I'd think that the MySQL will not be updated quickly because there must be testing and they won't risk crashing other customers with properly working scripts for another running a version of IPB that requires a newer database version. While I'm not terribly familiar with IPB, I am a programmer and my advice is to try to find an older version you can downgrade to because as soon as you fix one problem you'll probably uncover another problem since the version you are running depends on having 4.1 and we are running 4.0 on the server. I don't know if the techs can help with a MySQL upgrade so please look for the helpdesk ticket to be answered. I'm sorry you have had such a rough transition to your new home and maybe others here in the forums have done what you are trying and can help as well. Quote Link to comment Share on other sites More sharing options...
TweezerMan Posted November 3, 2005 Share Posted November 3, 2005 Welcome to the forums, mangla_nsit! Insulting and complaining about the people you want help from is not a good way to get help with your issues. With that said... Ive just realised that my previous webhosts were using version MySql 4.1.13 while you guys at TCH are using MySql 4.0.22 which is incompatible with the IPB forum software that IM using ! This statement is not accurate. IPB is compatible with both MySQL 4.0.x and 4.1.x. The problem here is that you are trying to import a MySQL 4.1.x database into a MySQL 4.0.x server, which generally will not work. You need to re-export your database from your old hosting account, making sure that the export is downgraded for use with a MySQL 4.0.x server. The MySQL documentation describes one method for exporting a downgraded database. If you phpMyAdmin available on your old hosting account, it may include the option to export a database and downgrade it to MySQL 4.0. The main problem Im facing is with respect to timestamps ! >timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, throws up errors when restoring database ! while it appears many times in the backup That is one of the incompatibilites between MySQL 4.0 and 4.1 (but by no means the only one): Changes in release 4.1.0 * Warning: Incompatible change! TIMESTAMP is now returned as a string of type 'YYYY-MM-DD HH:MM:SS' and different timestamp lengths are not supported. This change was necessary for SQL standards compliance. In a future version, a further change will be made (backward compatible with this change), allowing the timestamp length to indicate the desired number of digits of fractions of a second. In MySQL 4.0, timestamps are in the format of 'YYYYMMDDHHMMSS'. These formats are not compatible. I would fully expect errors to occur when importing timestamps in MySQL 4.1 format into a MySQL 4.0 database. There is nothing the Help Desk can do to assist you with this issue - they have no means to downgrade your data so it can be imported into a MySQL 4.0 server. You need to re-export and downgrade your data from your old hosting account while you still can. Otherwise, you are pretty much stuck. Quote Link to comment Share on other sites More sharing options...
TCH-Bruce Posted November 3, 2005 Share Posted November 3, 2005 Welcome to the forums, mangla_nsit Quote Link to comment Share on other sites More sharing options...
TCH-Thomas Posted November 3, 2005 Share Posted November 3, 2005 Welcome to the forum, mangla_nsit. Quote Link to comment Share on other sites More sharing options...
stevevan Posted November 4, 2005 Share Posted November 4, 2005 Welcome to the forums. (What David said.) Quote Link to comment Share on other sites More sharing options...
mangla_nsit Posted November 4, 2005 Author Share Posted November 4, 2005 Im sorry guys if Ive been rude Clarification: I never doubted the calibre of the TCH support team, but I thought maybe they had been unable to invest insufficient time to analyse my problem completely. Internet @ slow speeds and database restoration issues can be really frustating and I think I went overboard with expectations. Its not the best way to start a (hopefully) long term relationship but I hope you all understand Anyway, Ive resoled the issue stated above by simply removing the timestamp line from all the table backups and the forums seem to be running without a problem Apart from this, TCH rocks ! not only am I getting twice the specs of my prvious hosting account, the access speeds have improved tremendously! Server 92 rockz ! Quote Link to comment Share on other sites More sharing options...
Deverill Posted November 4, 2005 Share Posted November 4, 2005 I'm glad you got it worked out. Here's to many years of happy hosting! Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted November 4, 2005 Share Posted November 4, 2005 Welcome to the forums, mangla_nsit Glad you have it working. remember if you have server trouble, open a help ticket if you need help with scripts or other questions, ask your family here we love to help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.