Support Response History Ticket #106016 Created By Created On Summary John Zipperer 09/17/07 20:39:23 I was wondering how long it was going to be before we went full circle... ... Kevin OConnor 09/15/07 20:19:44 Hi, If you have installed this application from scratch and are still unab... John Zipperer 09/14/07 21:09:12 RESPONSE TO JOSEPH KOZAK 09/12/07: I tried the DB you restored and same th... Thomas Coates 09/14/07 11:47:26 Hi John, phpMyadmin is a php based application and does not require any se... John Zipperer 09/14/07 09:49:27 I have been doing research on phpMyAdmin and installing on a webspace and f... Kevin OConnor 09/13/07 11:18:49 Hi John, You can safely use this on your webspace without causing any dire... John Zipperer 09/12/07 20:12:10 RESPONSE TO GERRICK PHILLIPS 09/12/07 14:59:12 Now you have really peaked ... Gerrick Phillips09/12/07 14:59:12 Hi John, We appreciate your feedback regarding our shared Web hosting serv... Joseph Kozak 09/12/07 07:34:51 John, We have been able to restore the dump file, nuke.SQL, to a test DB o... John Zipperer 09/11/07 20:20:58 Ok I have ran every test I can think of and have passed it through 3 differ... John Zipperer 09/10/07 22:30:29 I really do appreciate the forwarding of a possible update of your Database... Joseph Kozak 09/10/07 08:26:55 John, Please resend the files, or just upload then to a folder in one of y... John Zipperer 09/10/07 01:47:23 To the response of Kevin OConnor on 09/07/07 at 10:39:28.. I know Joseph Ko... John Zipperer 09/10/07 01:22:12 First I can not believe I have to retype this cause I guess I made it too l... Kevin OConnor 09/08/07 19:28:11 Hi, As previously stated, if you need to restore a backup, please provide ... John Zipperer 09/07/07 23:26:47 Ok maybe I am not being clear on this... I know it is saying the sql line i... Kevin OConnor 09/07/07 10:39:28 Hi John, We have responded to your ticket in the Control Panel on 8/27/07 ... John Zipperer 09/06/07 16:12:16 Re: Easy CGI Support Response [EASYCGI:106016] Joseph Kozak 08/27/07 07:20:23 John, We will be using the .sql dump to see if we can replicate any errors... John Zipperer 08/25/07 18:56:50 So you want me to send you the .sql each time I need something added to the... Kevin OConnor 08/23/07 12:04:48 Hi, Please provide us with the .sql backup file of your database and let u... John Z 08/22/07 19:34:55 Re: Easy CGI Support Response [EASYCGI:106016] Joseph Kozak 08/22/07 07:26:34 John, You wrote in another ticket: "Ok.. I have been talking to alot of p... Richard Chang 08/01/07 17:41:41 Re: Easy CGI Support Response [EASYCGI:106016] John Z 07/31/07 20:54:15 Re: Easy CGI Support Response [EASYCGI:106016] Justin Penchina 07/31/07 19:52:51 Hi, This email is a confirmation of the request to migrate all MySQL datab... 07/31/07 19:52:51 This email is a confirmation of the request to migrate all MySQL databases in your Easy CGI account to another database server. The migration will be done as follows: Old Server: zgrafx.easycgimysql.com New Server: zgrafx.easycgimysql.com It is strongly recommended that you create a "dump" backup of your MySQL database prior to confirming this migration. The InnoDB table type of MySQL is not supported for migration. All InnoDB table data will be permanently lost upon migrating a database, and manual intervention will be required to allow the table to be reconstructed. Please confirm all the information above and we will be happy to move forward with your MySQL database migration. Best Regards, 07/31/07 20:54:15 I John Zipperer do confirm this action and would like to be notified when the action is complete so I may upload and reset all my MySQL databases I currently have dumped.. Thank again for all your help and am glad the service of your company has not gone down over the last 4 years I have been with you.. Great job guys... 08/01/07 17:41:41 Support Response: Hi John, We have moved your account to a new MySql server, zgrafx.easycgimysql.com. If you have any further questions, please feel free to contact us. Regards, Richard Chang 08/22/07 07:26:34 John, You wrote in another ticket: "Ok.. I have been talking to alot of people in the PhP Community and they are all pretty much on the same agreement that there is nothing that I am doing wrong and that the version of phpMyAdmin and MySQL that is on the newer server is an unstable version and has been replaced over a year ago.. My question is I did not have any problems on the other server (older server I started on 5 years ago) so is it possible to switch me back and then we can see what happens then.. Thank you for your help resolving this issue and I hope we can get this figured out... Thanks.." Can you please elaborate on the issue that you are experiencing regarding your MySQL database, so that we can better evaluate your migration request and see if we can offer you any other assistance. Please do not hesitate to contact us if you have any further questions. 08/22/07 19:34:55 Nuke Versions: nCo Modified 7.6 Ultra PhPNuke 8.0 Platinum 7.6b4v2 Hosting providers MySQL info on Windows: phpMyAdmin 2.6.2pl1 MySQL Client 5.0.27 Local PC Hosting MySQL info on Windows: phpMyAdmin 2.8.0.3 MySQL Client 5.0.20 ISSUES ----- : ON local PC hosting everything works good (problems with user reg at first but figured that out) on all 3 versions... ON hosting provider I get errors when uploading the sql tables.. If I take the backups of my local sql and upload to the hosting provider they will insert completely but it will not input data into the DB properly especially the user registration tables in particular moving the data from user_temp to user after verifying reg with email and without email.. If I take the original sql file and upload it I get errors about "line to long", I have included screenshot of the errors.. I finely got the Platinum SQL to go in but then a admin loop issue which I am dealing with on their forums.. Please check out the screenshots and any help would be very appreciated... If you need more info let me know and Ill get it to you.. Thanks again... 08/23/07 12:04:48 Hi, Please provide us with the .sql backup file of your database and let us know which file should be restored to which database and we will restore it for you. Please let us know if you have any further questions. Best Regards, 08/25/07 18:56:50 So you want me to send you the .sql each time I need something added to the DB or are you looking to try it and see what you get as a diagnostic tool.. If it is the first then please lets not go there, I refuse to send you the file each time one of my 218 members I had on my other site wants to register or change anything.. What else can be done, can I be moved back to the other server as it was before all this started back on 7-13-07..? I think I have been pretty patient with this consider I have had this account for 5 years and not a problem before the migration on 7-13.. If I can not get back on the other server or this figured out then I am not sure what to do considering I have 2 business sites for clients that were accually running on here before and there sites have been down since, I have to think of my business first and foremost, like I said 5 years has been a long time (probally longer then some of your employees since you are the 2nd owners since I started with easycgi) and I can not lose my customers.. 08/27/07 07:20:23 John, We will be using the .sql dump to see if we can replicate any errors while restoring your database to the MySQL server, using the command line to restore your database, rather then using the PhpMyAdmin to restore your database. Please also give us something specific to look for once the database, once restored, to verify the issue. Do not hesitate to contact us if you have any further questions. 09/06/07 16:12:16 Sorry but I am checking in to see what how it is going.. I still havent heard anything wither you got it to work or not.. Is there still an issue or is it fixed.. Please reply so I know what I am doing PLEASE.. Thank you.. It kind of sucks that I am still paying my monthly fees for a service I have had for over 4 years and havent been able to use that same service for going on 6 weeks now.. 09/07/07 10:39:28 Hi John, We have responded to your ticket in the Control Panel on 8/27/07 at 7:20:23 AM EST. Please insure you are checking the Help and Support -> Support Tickets section of the Control Panel periodically for updates. The reason you are receiving this error is because you are attempting to send a line of SQL that is larger than our server allows. You may rectify this by breaking up a single large line into smaller SQL queries, or alternatively, provide us with the SQL backup so we may restore it. After your database has been restored, you should be able to add/delete users, manage content, and all the other normal functions of your CMS without having to go through this procedure again. This is only necessary due to the fact that you are performing a full restore. Best Regards, 09/07/07 23:26:47 Ok maybe I am not being clear on this... I know it is saying the sql line is to long and that it will not load it up,, I know I can do a restore of a back up that I have on my sys.. BUT what I dont know is why all of a sudden after I get MIGRATED from the old server I HAVE been on for the last 4 years to the newer server you have that now the SQL file I have been using for that same 4 years on the older servers will not work now or I should say your sql servers will not take it due to the line being to long now... I am pulling my hair out getting the run around here and I am getting very frustrated... I have done the restore of the backup and it will NOT write to the database if a new user registers on one of my sites.. I have told you all that in a previous email.. The answer is not restoring a backup especially if you are wanting a backup of the database from your older server the I do not have (the backup I have is from a newer version of MyAdmin and SQL so it will not be compatible with your ANCIENT version of MyAdmin and SQL), the answer should be finding out why your SQL Database is not excepting the original file.. 09/08/07 19:28:11 Hi, As previously stated, if you need to restore a backup, please provide us with the .sql file and we will restore it for you. If you are having issues registering users after the restore due to database errors, please provide us with a URL to the page in question as well as any steps that we will need to take to replicate the problem and we will assist you further. Please let us know if you have any further questions. Best Regards, 09/10/07 01:22:12 First I can not believe I have to retype this cause I guess I made it too long and my session timed out, Ill try to make this one shorter... I can not believe no one can answer my question why a PhP-nuke version I have been using for 4 years now on your systems will not load up after the migration so I guess I have to be inconvenienced by using a PhP-Nuke version I am not familiar with and rebuild all my client sites for FREE, Thanks for this one.. Do not ask for a back up of the database again please cause I do not have one and dont you think that if I did then if an original not added to sql datasheet will not load due to a "table line to long" error that the backup of a sql that did have long data tables would not load either.. make sense to me... As Kevin OConnor stated in the last message "If you need to RESTORE a backup", well that is not what I need, I need to be able to install (upload) a stock clean sql file especially for the new sites that I would have been starting on instead of messing around with this for over a month.. Restore is not the answer to this one but I am curious why you are still using a phpMyAdmin that came out on 5/5/05 that actually had known errors that pertain to this and has been replaced numerous time over the last 2 1/2 years and the current version is 2.11 which will actually be the last version to support PHP4 due to almost all the the PhP-Nuke Cores will be updated to PhP5 so what is going to happen then, are we going to be stuck having to use old not so secured portals if we want to stay with the #7 Top Web Hosting Companies on the net today.. I did have a backup of one of my sites that did work before the migration... Go to http://darknessgames.com and try to register.. What that one is doing is it drops the data from user_temp to user when activating an account which had no problems with before and that is a full backup of the site including the site files.. Thanks and Ill get back to you if this other version does not work and please can someone figure out what had changed when migrated or even tell me what the difference is between zgrafx.easycgimysql.com and zgrafx.easycgimysql.com cause didnt have these problems on mysql1.. 09/10/07 01:47:23 To the response of Kevin OConnor on 09/07/07 at 10:39:28.. I know Joseph Kozak responded on 8/27 and I responded back with this via email on 8/29... "Sorry about the delay but been very swamped lately.. Here is the stock .sql file (for the nCoNuke version) which is the most important one of the 3 version I currently use.. The error it keeps giving is "Unknown Punctuation String and #1406 Data too long for column", screenshot included as attachment.. Thank you for all your help and if it works for you please let me know the steps you used so I can try it on this side.." I noticed that response did not show up in the Support Response History so wanted to put it in now so there was a record.. If you did not get the email or files let me know and I can resend them.. Thanks 09/10/07 08:26:55 John, Please resend the files, or just upload then to a folder in one of your web sites, and we will be able to access it from there. Your request regarding the upgrade of the phpmyadmin version has been sent to management for review, and we are still looking into the rest of this issue. Please do not hesitate to contact us if you have any further questions. 09/10/07 22:30:29 I really do appreciate the forwarding of a possible update of your Database, I feel someone accually is listening to their customers, Thanks.. Now that I through my shoulder out giving highfives, LOL, I uploaded the .sql file and the screenshot of the db error to zgrafx.com/websites/nCoModified76/sql directory. In the nCoModified76 directory I have put all the stock files and stock .sql for that version of Nuke, the one that was being used on your servers for the 4 years on zgrafx.easycgimysql.com, in case you needed a test site for troubleshooting purposes. If there is anything else you need please feel free to asking, I will help all I can to get this figured out too... I am still testing the other version of Nuke that I mentioned in the other message, it has bugs still figuring out but the sql file loaded as much as I can tell so far.. One bug is Register/Login so really havent been able to test the sql integrity yet.. Hopefully will have the bugs worked out in the next couple of days.. Again if you need anything else just ask and Thanks for all the help in this issue.. 09/11/07 20:20:58 Ok I have ran every test I can think of and have passed it through 3 different versions and their respective communities and have the same error on each one.. When I run the error loggers they all come back with the same thing so I am just not sure what to do now.. Waiting to see what happens on your end to see where I have to go from here... The error returned is: "ERROR: There was a problem with the database." Thanks for any and all help you are giving in this issue and hope between all of us we can get this licked... 09/12/07 07:34:51 John, We have been able to restore the dump file, nuke.SQL, to a test DB on your server. nukecode_test Please test this database and see if you are still having any issues. 09/12/07 14:59:12 Hi John, We appreciate your feedback regarding our shared Web hosting services. Within our shared environment, we attempt to provide support for the most widely used and common technologies. While we do have future plans to upgrade the version of phpMyAdmin running globally for shared hosting customers. However, there is no current ETA on implementation. However, with phpMyAdmin being a web based management system, we can suggest uploading a newer version to a directory in your webspace. While we will not offer direct support for it, you should still be able to manage your MySQL databases using an updated version running in your web space. Downloads are available at http://www.phpmyadmin.net/home_page/index.php. Please let us know if you have additional questions. Regards, 09/12/07 20:12:10 RESPONSE TO GERRICK PHILLIPS 09/12/07 14:59:12 Now you have really peaked an interest.. I did not know that I could run phpMyAdmin on my webspace and I would really like to know how I can without getting a email from you all about using too much CPU Usage (A bud of mine got dropped due to this and we never found out what was using the CPU Usage) A few things I need to understand or respond to though..: 1) "Within our shared environment, we attempt to provide support for the most widely used and common technologies." The phpMyAdmin version that you are using is not and has not ran on just about every webhosting service out there for well over a year now, I have checked with approximately 28 companies over the last week to figure out my options with my current issues.. When I even mentioned about what version they are running and asked about version 2.6.11pl1 one company actually laughed. The oldest version I have found out there was 2.9.2 and they have updated about 6 months ago according to them.. Not tring to tell you your biz but just offering some info if needed.. 2)"However, with phpMyAdmin being a web based management system, we can suggest uploading a newer version to a directory in your webspace. While we will not offer direct support for it, you should still be able to manage your MySQL databases using an updated version running in your web space." This is very interesting to me, how would I go about doing this cause if it can be done and is within my terms of agreement with you then by all means that would solve most if not all the issues currently having.. To what I know about it it can be loaded and ran from an Apache server but wouldn't that have to be loaded in my webspace too (as in XAMMP which I run on my base PC's with the most current Apache and MySQL out to date). How would I execute this without CPU Usage of your servers.. Like I said this does interest me and would like all the info on it I can get, is it something you all would know or would I have to get with the guys on Apache Forums.. Thank you for any and all info that has been transfered between us and Thank you for all the help.. 09/13/07 11:18:49 Hi John, You can safely use this on your webspace without causing any direct issues for other customers on your server. If you do somehow create a high usage situation, we will warn you before removing you from our service, and give you a chance to remove the offending files before we proceed any further. We will also let you know exactly which files are causing the usage, so it will be very easy to see that phpMyAdmin is the culprit. You can find further information on installation and configuration at http://phpmyadmin.net/. Please let us know if you have any further questions. Best Regards, 09/14/07 09:49:27 I have been doing research on phpMyAdmin and installing on a webspace and found out that I need MySQL also... Is this going to able to be done also... I am researching on how to install it remotely but only finding how to install locally so still looking.. I havent tested the sql bd that you all finelly got uped and will be testing that tonight after work... Thanks for all the help and any more info is greatly appreciated.. 09/14/07 11:47:26 Hi John, phpMyadmin is a php based application and does not require any server side installations of apache. It will run from a directory on your webserver with minimal configuration. Just upload the files, edit the config, and you should be ready to go. A standard phpmyadmin should not use excessive resources, though I cannot promise that, as phpmyadmin is a very in depth program, which can actually execute queries that cause excessive CPU. Please let us know if you have any further questions. Best Regards, 09/14/07 21:09:12 RESPONSE TO JOSEPH KOZAK 09/12/07: I tried the DB you restored and same thing... Not able to Register, give it a try... http://zgrafx.com/websites/nCoModified76/index.php This is a 100% Stock test site that has had nothing done to it except set the site home address so the links and register would work, or atleast they should have.. 09/15/07 20:19:44 Hi, If you have installed this application from scratch and are still unable to register new users, you should review the installation instructions included with the application, and if you are still having issues contact the vendor of the application for further support. As there are no error messages appearing when the user is registered and then authorized, we believe this is an application error as opposed to a system error. Please let us know if you have any further questions. Best Regards, 09/17/07 20:39:23 I was wondering how long it was going to be before we went full circle... First: "If you have installed this application from scratch and are still unable to register new users, you should review the installation instructions included with the application, and if you are still having issues contact the vendor of the application for further support." I really don't have to read the installation instructions on a PhP-Nuke version that I have been using for the last 4 YEARS (maybe I haven't said that enough here), it is not a newer version nor a different download, I have been installing and using nCo Modified v7.6 Ultra for this whole time and it is the same download I have installed this whole time.. There hasn't been a issue in the past with this same set of files so why would there be an issue this same set of files now, the only denominator that has changed is the migration from zgrafx.easycgimysql.com to zgrafx.easycgimysql.com. I have contacted the NukeCode multiple times in their forums for support and have concluded it is an issue on my hosting side. Second: "phpMyadmin is a php based application and does not require any server side installations of apache. It will run from a directory on your webserver with minimal configuration. Just upload the files, edit the config, and you should be ready to go." This is only half of the truth I have come to find out, you can not run phpMyAdmin without a connection to a MySQL Database and THAT can not be loaded to a webspace. I have contacted mysql.com and phpmyadmin.net and they have both stated that phhpMyAdmin needs a MySQL connection or it will not work and mysql stated that you can not have a remotely installed MySQL DB cause of all the security issues and risks, and also stated that it sounds like "Your host has changed some internals, thereby either exposing or creating problems with your code. I've seen it often with PHP sites." Here is the link to all the forum info from mysql.com, http://forums.mysql.com/read.php?10,173156,173156#msg-173156 Final thought: I am still wondering why if everything was working perfect before the migration back on 7-31 (which I wish I would have never agreed to do now) when I was on mysql1, why havent I been changed back to see if that clears anything up. I am a Computer/Graphic Tech and the first thing you are tought as CS is Troubleshooting, the first line should have been take out the changed denominators and tech from there. The site software has not changed, the webspace has not changed, the uploading software has not changed, the order and sets of configurations has not changed, the only thing that has changed was the MIGRATION... Thank you for any and all the help in this mess and hope between all our heads we get to a solution..