Guest kevin Posted December 11, 2014 Share Posted December 11, 2014 In my local test setup with PHP / javascript it all works but when deployed onto phpnet my sql queries have database name prepended to table name by the mysql engine. Presumably a function of the way the app has connected to the db or permissions but I cannot see anything that refers to this behaviour anywhere and am at a loss to fix. Any help would be welcome. Quote Link to comment Share on other sites More sharing options...
Guest hostddl Posted December 11, 2014 Share Posted December 11, 2014 Hello, Unfortunately, we can not help you for the development of a specific php script we recommend you to search for a solution on a specialized forum or hire a developer. If you think that the error comes from our hosting platform please contact [URL="https://support.ifastnet.com/"]support[/URL]. Don't forget to check our [URL="https://kb.securesignup.net/"]Knowledge Base[/URL]. Quote Link to comment Share on other sites More sharing options...
Guest kevin Posted December 11, 2014 Share Posted December 11, 2014 Hi, I don't want help with a specific php script the question is [I][B]generic[/B][/I]. The database has been successfully ported onto phpnet. The setup on my local machine and on phpnet look the same but PHP queries on phpnet are complaining that tables of the form . don't exist. This does not happen on my local machine. The SQL does not refer to it only refers to , the database is defined on phpnet, it is browseable in phpmyadmin, and the correct connection strings are used in the creation of the PDO object. This what I'd like help in understanding. thanks Quote Link to comment Share on other sites More sharing options... Guest kevin Posted December 11, 2014 Share Posted December 11, 2014 Actually I'm thinking it's down to the db engine. I used innodb whereas it is created on phpnet as MyIsam. Quote Link to comment Share on other sites More sharing options... Guest hostddl Posted December 11, 2014 Share Posted December 11, 2014 yes it can be an issue please open a ticket to see if we can help here : Quote Link to comment Share on other sites More sharing options... Join the conversation You can post now and register later. If you have an account, sign in now to post with your account. Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below. Reply to this topic... × Pasted as rich text. Paste as plain text instead Only 75 emoji are allowed. × Your link has been automatically embedded. Display as a link instead × Your previous content has been restored. Clear editor × You cannot paste images directly. Upload or insert images from URL. Insert image from URL × Desktop Tablet Phone Submit Reply Share More sharing options... Followers 0 Go to topic listing All Activity Home General Webmaster Stuff MySQL, PHP, Perl and CGI Community forum How to avoid database name being prepended to table name i queries × Existing user? Sign In Sign Up Browse Back Browse Forums Staff Online Users Activity Back All Activity Search × Create New...
Guest kevin Posted December 11, 2014 Share Posted December 11, 2014 Actually I'm thinking it's down to the db engine. I used innodb whereas it is created on phpnet as MyIsam. Quote Link to comment Share on other sites More sharing options...
Guest hostddl Posted December 11, 2014 Share Posted December 11, 2014 yes it can be an issue please open a ticket to see if we can help here : Quote Link to comment Share on other sites More sharing options...
Recommended Posts