brucewin
Posts: 143
|
| Posted: 11/28/2005, 4:36 AM |
|
I am using the Apache server (xampp) on my desktop.
Windows XP personal
CCS 3.0 Trial Version
This project is the Tasks application that came with the trial version.
Can't connect. If anyone has time to take a look at my problem, this is what I am doing, and my settings are all here.
http://www.justbillme.net/DemoCalendarHelp.html
2 demo files are on a web page for easy viewing of my problem on my remote server, not my desktop Apache Server.
Help, I am going crazy with this.
Bruce
|
 |
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 10:51 AM |
|
Hi Bruce,
I've looked at both your demos at the above URL, but didn't see any errors or problems in the demos. Also, both demos show the calendar usage, but not the Task application.
Are these the right demos?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Walter Kempees
|
| Posted: 11/28/2005, 10:55 AM |
|
no peterr see next item same thread.
please advise
"peterr" <peterr@forum.codecharge> schreef in bericht
news:2438b519d94460@news.codecharge.com...
> Hi Bruce,
>
> I've looked at both your demos at the above URL, but didn't see any errors
> or
> problems in the demos. Also, both demos show the calendar usage, but not
> the
> Task application.
> Are these the right demos?
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
brucewin
Posts: 143
|
| Posted: 11/28/2005, 11:14 AM |
|
correct URL http://justbillme.net/DemoHelp.html
|
|
|
|
Walter Kempees
|
| Posted: 11/28/2005, 11:28 AM |
|
You are really a funny quy.
Is this response your last response, or is it in the other thread?
If this is your last than you did not read my post in the other thread. But
from your response I know you did read it.
Greetz,
Walter
"brucewin" <brucewin@forum.codecharge> schreef in bericht
news:2438b571b72a4c@news.codecharge.com...
> correct URL http://justbillme.net/DemoHelp.html
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 11:33 AM |
|
I don't think that there is a way to connect directly to MySQL on Windows, so you would need to use ODBC. So change the Server database settings (PHP Database Library) from "MySQL" to "ODBC", then select MySQL.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 11:37 AM |
|
I also just found the other thread...
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
brucewin
Posts: 143
|
| Posted: 11/28/2005, 11:54 AM |
|
I made the changes, but when I publish and go to the live tab, after I enter in admin, admin. I get this:
Database error: mysqli_connect(localhost,root,$DBPassword,Bruce3,0,)failed. MySQL Error
Session halted
|
|
|
|
Walter Kempees
|
| Posted: 11/28/2005, 12:27 PM |
|
bruce,
stop this thread.
reread the other thread.
Do as I say there, to which you actually already responded with a thank you.
Than it will work.
Peterr
He is running Winamp, local apache local mysql
direct connect is one of the advantages of using that setup.
He just has to go to CONNECTION
SERVER
and put the details inthat are in the other thread.
Walter
"brucewin" <brucewin@forum.codecharge> schreef in bericht
news:2438b607c70300@news.codecharge.com...
>I made the changes, but when I publish and go to the live tab, after I
>enter in
> admin, admin. I get this:
>
> Database error:
> mysqli_connect(localhost,root,$DBPassword,Bruce3,0,)failed.
> MySQL Error
> Session halted
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 1:04 PM |
|
Walter,
I locked the other thread to avoid confusion. If you like please repost your solution here.
Bruce,
It seems that your Common.php was manually modified or corrupted, because no matter what settings you select in CCS, you always get the same error about mysqli.
Please backup and delete your Common.php from your project folder, then select "MySQL" in Connection/Server. Then when you republish the correct Common.php should be generated with the new settings.
If this doesn't work then select "ODBC -> MySQL" in Connection/Server.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Walter Kempees
|
| Posted: 11/28/2005, 1:13 PM |
|
peterr, thanks.
Bruce follow peterr's advice and then:
repost of previous message:
you are not showing the server settings for you connection
In the Project Settings
Connections
click modify on Intranet
click on server
Fill the fields like this:
Date Format : mm/dd/yyyy HH:nn:ss
Boolean Format true;false
Use limit/top checked
PHP Database Library: MySQL
Datavase or ODBC connection name (we will NOT use ODBC for server): intranet
Host : localhost
Login: root
Password: e<empty>
Press OK to close this screen
Press OK to close Connection
Publish !
et voila
<=====================>
You are using Improved MySQL in stead of MySQL in your SERVER settings!
change it to MySQL.
Peterr
There is no such limitation (direct connect to MySQL on Win not possible) in
the Trial is there?
Walt.
"peterr" <peterr@forum.codecharge> schreef in bericht
news:2438b70db7c651@news.codecharge.com...
> Walter,
> I locked the other thread to avoid confusion. If you like please repost
> your
> solution here.
>
> Bruce,
> It seems that your Common.php was manually modified or corrupted, because
> no
> matter what settings you select in CCS, you always get the same error
> about
> mysqli.
> Please backup and delete your Common.php from your project folder, then
> select
> "MySQL" in Connection/Server. Then when you republish the correct
> Common.php
> should be generated with the new settings.
> If this doesn't work then select "ODBC -> MySQL" in Connection/Server.
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
brucewin
Posts: 143
|
| Posted: 11/28/2005, 1:25 PM |
|
Peter I did what you said, deleted file and tried both ways. Still the error message. Walter I did what you said still the error message. I just unistalled the trial version, and reinstalled it to see if that would help. I'll let you know. Bruce
Thanks
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 1:45 PM |
|
Bruce,
One another possibility is that "C:\Program Files\xampp\tasks1" is not mapped to the server URL "http://localhost/tasks1".
You could try deleting all files from "C:\Program Files\xampp\tasks1" and then check in a Web browser if "http://localhost/tasks1" still works.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
brucewin
Posts: 143
|
| Posted: 11/28/2005, 2:16 PM |
|
Guess what? It works. I unistalled CCS, then reinstalled it.
I deleted my directories that I published to. I recreated 1 new directory C:\Program Files\xampp\htdocs\taskpublish
I used the settings that Walter supplied. Thanks to both of you, it has been a great help.
Do you think that changing where I published the project did anything?
|
|
|
|
Walter Kempees
|
| Posted: 11/28/2005, 2:29 PM |
|
Like I tell everybody asking me "how come....", it might be a Miracle,
Coincidence or bad advise, who cares, we are there!
"brucewin" <brucewin@forum.codecharge> schreef in bericht
news:2438b81b01d2e0@news.codecharge.com...
> Guess what? It works. I unistalled CCS, then reinstalled it.
>
> I deleted my directories that I published to. I recreated 1 new directory
> C:\Program Files\xampp\htdocs\taskpublish
>
> I used the settings that Walter supplied. Thanks to both of you, it has
> been a
> great help.
>
> Do you think that changing where I published the project did anything?
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2005, 2:54 PM |
|
Great.
I see that your previous GIF was showing the publishing directory as "C:\Program Files\xampp\tasks1", while now you are using "C:\Program Files\xampp\htdocs[/b\...]". I suspect that this was the problem (not publishing to "htdocs").
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
 |
|
|
|
