Announcement

Collapse
No announcement yet.

Can't choose Database Name in PROD environment

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • rr
    replied
    phpinfo is what you are searching for... phpinfo();

    Leave a comment:


  • aka
    replied
    I have similar problem. I have testing site running on XAMPP v1.7.7 (believe it is PHP v5.3.8)
    MySQL is up and running on remote server (so I used server IP). When I open Connection settings for the App I can run Connection test and it is successful, but when trying to select database from the dropdown list it takes forever and nothing ever shows up...

    I'm going to d-load the database and set it up locall to see if this would work, although this isn't the way I want it setup.
    I think SC should allow to type in a database name manually as well then trey to connect later. At this moment is work the other way around. It tries to connect and pull database list, then it connects. Both scenarios should work.

    Arthur

    PS>
    I forgot, what was the command to test PHP version on remote hosting server ?
    Last edited by aka; 08-05-2014, 12:37 AM.

    Leave a comment:


  • Giu
    replied
    Originally posted by ajhernan View Post
    Hello again:

    In may previous post I said that my PHP version was 5.4.20, but it was a mistake. these was the result of may scriptcase diagnosis. My PHP version is 5.5.9 and as I red I need PHP 5.4 to work fine in production environment.

    The problem is that ubuntu 14.04 LTS comes with PHP 5.5 and it's not easy to downgrade PHP 5.4. Then previous ubuntu 12.02 LTS comes with PHP 5.3.10, but you can upgrade to php 5.4.20 easily. Therefore, I think that while ScriptCase not support php 5.5 is recommended to use ubuntu 12.02 winth PHP 5.4.20

    The question is whether to have the php version 5.5 instead of 5.4 is the reason that no databases appear in the drop down list and when ScriptCase will support php 5.5?
    You can override PHP version with .htaccess AFAIR

    If not, you can use vhosts using a different PHP version too. PHP 5.4 and 5.5 and 4, can live in the same enviroment, you don't need to downgrade all system.

    Leave a comment:


  • ajhernan
    replied
    Hello again:

    In may previous post I said that my PHP version was 5.4.20, but it was a mistake. these was the result of may scriptcase diagnosis. My PHP version is 5.5.9 and as I red I need PHP 5.4 to work fine in production environment.

    The problem is that ubuntu 14.04 LTS comes with PHP 5.5 and it's not easy to downgrade PHP 5.4. Then previous ubuntu 12.02 LTS comes with PHP 5.3.10, but you can upgrade to php 5.4.20 easily. Therefore, I think that while ScriptCase not support php 5.5 is recommended to use ubuntu 12.02 winth PHP 5.4.20

    The question is whether to have the php version 5.5 instead of 5.4 is the reason that no databases appear in the drop down list and when ScriptCase will support php 5.5?

    Leave a comment:


  • ajhernan
    replied
    Hello,
    I have the same problem. I can't choose a database.

    My environment is:
    ubuntu 14.04.1
    Zend 3.3
    PHP 5.4.20
    Apache/2.4.6
    MySQL Server version: 5.5.38-0

    ScriptCase Devel: 8.0.000
    ScriptCase Prod: 7.1.010

    Can someone choose the database in the scriptcase production environment with PHP 5.4 or higher?

    Pleased, it's very urgent!!
    Attached Files
    Last edited by ajhernan; 07-31-2014, 08:50 PM.

    Leave a comment:


  • adz1111
    replied
    I concur with lanrobo - this is causing me a huge problem as downgrading is also just not an option. Does or will SC 8 resolve this? If so when is it expected to be made available?

    bartho - "mysqlshow" from the command line shows the databases fine whether as root or a different user
    Last edited by adz1111; 06-11-2014, 11:38 AM.

    Leave a comment:


  • lanrobo
    replied
    Has this been resolved? It looks like the initial post was 6 months ago. Downgrading PHP to a lower version is not an option, nor an acceptable solution.
    Even if in the interim you provide a way to manually edit the configuration file, if possible, that would suffice. I am unable to use this software as advertised because of this flaw.
    Thanks.

    Leave a comment:


  • bartho
    replied
    Hello guys,

    Could the issue be related to MySQL's show database on your prod environment? http://dev.mysql.com/doc/refman/4.1/...databases.html

    regards,
    Bernhard Bernsmann

    Leave a comment:


  • deltanadir
    replied
    Hi everyone,
    Same problem with me, the databases are accessible if keep the same name as development environment, the only thing is that i can't select a database, the combobox is empty...

    (PHP 5.5)

    Leave a comment:


  • asawyer13
    replied
    I am having this issue also, but using PHP 5.4.
    Any help would be appreciated as this is stopping me from installing on this server.

    Leave a comment:


  • mikelaw
    replied
    I come across this problem, as far as im aware it's because MySQL extension is deprecated in PHP 5.5.x. You will have to update your database to MySQLi or a run your app on a server running PHP 5.4.x or lower. This is as much as i know and i don't think it's a problem with Scriptcase.

    Leave a comment:


  • jorgeac12
    replied
    Originally posted by John L. Santos View Post
    Hello Mr. Igor,

    This problem occurs because the version of PHP 5.5 and not the version of MySQL
    This is just a warning message, but I do not know why Scriptcase is not listing databases.
    We are checking this problem.




    You can use PHP version 5.4 without problems.
    Any news about this problem?

    Leave a comment:


  • baldazar
    replied
    Originally posted by John L. Santos View Post
    Hello Mr. Igor,

    This problem occurs because the version of PHP 5.5 and not the version of MySQL
    This is just a warning message, but I do not know why Scriptcase is not listing databases.
    We are checking this problem.
    Any news about this problem?

    Leave a comment:


  • bartho
    replied
    Originally posted by ajhernan View Post
    Hello John,

    I have the same problem with PHP 5.4.20, could you tell me when scriptcase think to resolve this bug. I'm right in the implementation phase of a project and this issue is currently the biggest drawback for me.

    Thanks
    Some Databases have a configuration to List (or not) all databases. That may be what is causing the issue.

    regards,
    Bernhard Bernsmann

    Leave a comment:


  • ajhernan
    replied
    I have the same problem with PHP 5.4.20

    Originally posted by John L. Santos View Post
    Hello Mr. Igor,

    This problem occurs because the version of PHP 5.5 and not the version of MySQL
    This is just a warning message, but I do not know why Scriptcase is not listing databases.
    We are checking this problem.




    You can use PHP version 5.4 without problems.
    Hello John,

    I have the same problem with PHP 5.4.20, could you tell me when scriptcase think to resolve this bug. I'm right in the implementation phase of a project and this issue is currently the biggest drawback for me.

    Thanks

    Leave a comment:

Working...
X