Forums Sign Up Reply Search Statistics
PHP/JAVA CLASS Code Generator GraFX Software Solutions - Forum / PHP/JAVA CLASS Code Generator /

fails to find the database name

 
M4ngo
Forums Member
#1 Posted: 16 Jul 2008 01:46:48
Reply 
downloaded and ran the code - generating from the database connection - fails with message:

"I cannot select the database because the database name does not exist!"

However I have triple checked the info and what I am entering is correct. Any hints or do I have to debug this....
software
Admin
#2 Posted: 16 Jul 2008 02:45:25
Reply 
Cannot select the database, means username and password is OK, but the database is not exist, or is not connected to the user.
M4ngo
Forums Member
#3 Posted: 16 Jul 2008 12:42:14
Reply 
I have debugged into the code and found the location of the problem but not why:

on line 24 in begin.php it tries to connect to my database:

$cid = @mysql_connect($all_url_vars["url"],$all_url_vars[ "logid"],$all_url_vars["pasw"]) or die("I cannot select the database because the database name does not exist!</br> Go back <a href='index.php?page=host'> prev</a>.</br> Write correct information!");

The NEXT line tries to select the database catalog/schema BUT - it never gets there - so the error message is misleading. In fact it cannot make a connection at all to the database.

So - I test:

$t = mysql_connect('localhost', 'root', 'mypassword') or die('cannot connect);

HOWEVER - this works FINE!

I go back and inspect the variables being passed in begin.php and they are all perfectly correct.... I am stumped. Any more ideas?


however
M4ngo
Forums Member
#4 Posted: 16 Jul 2008 12:43:32
Reply 
INTERESTING...

I just created a new user in the MySQL administrator (I was using root before) and it works!

I wonder about the password for my root user. It doesnt have any extended ascii characters but it does have an exclamation mark... I wonder?....
M4ngo
Forums Member
#5 Posted: 16 Jul 2008 12:53:22
Reply 
OK - so after looking at what this does much more closely I am afraid its not quite what I want.... No offense it still pretty cool - but I was really hoping to get:

1) A system that would iterate through every table and create a class automatically for each. As it stands I have to repeat several steps for every table I have (I have about 50)

2) Requires very little input to choose class names and variable names (etc). As it stands I have to pick this stuff myself.

3) Can identify the object instances a little more dynamically. As it stands, I have to pick an identifying collumn myself ...

4) Generates some what more comprehensive code....

So - thanks very much - I really do think your system is great - but its a little short of what I am looking for. Having said that - do you know of any system that is closer to what I am looking for? Even commercial - I will pay.

Thanks again!
software
Admin
#6 Posted: 16 Jul 2008 13:11:58
Reply 
we don't know what will generate more better code, is depend on your need, BUT you can extend out code and use it or share it, we are open to extend it. :-)
 
Your reply
Bold Style  Italic Style  Image Link  URL Link 

» Username  » Password 
Only registered users are allowed to post here. Please enter your login/password details upon posting a message, or sign up first.