cramblit
Posts: 4
|
| Posted: 12/02/2004, 4:51 PM |
|
I've been looking for a pre-built Task Manager. Thought I found my solution on what may be an old site www.gotocode.com. What I downloaded is OLD Generated with CodeCharge 1.1.18
PHP & Templates build 03/28/2001. That's fine with me!
I was looking for pre-built because I am NOT a real coder. I just scrape by with these PhP/SQL programs.
I got the database installed. Changed the info for the connection string and hit this error when attempting to LOGIN
Fatal error: Call to undefined function: odbc_pconnect() in /home/maguire/public_html/tasks/db_odbc.inc on line 35
The problem is in this file "db_odbc.inc" which is included in the "common.php" file
This appears to be the source of the problem
var $UseODBCCursor = 0;
This is where the error is coming from. Line 35 is BOLD.
Sure appreciate any help. I've never seen this ODBCCursor before in any of the probably 20 PHP/SQL programs I've set up. Should it even be there?
function connect() {
if ( 0 == $this->Link_ID ) {
$this->Link_ID=odbc_pconnect($this->Database, $this->User, $this->Password, $this->UseODBCCursor);
if (!$this->Link_ID) {
$this->halt("Link-ID == false, odbc_pconnect failed");
Thanks Very Much!
_________________
Joe |
 |
 |
peterr
Posts: 5971
|
| Posted: 12/02/2004, 11:21 PM |
|
You would need to install PHP with ODBC support. See http://us2.php.net/odbc
Alternatively, you can download the free trial version of CodeCharge Studio and generate your own Task Manager with the database settings that you want. The instructions are at http://docs.codecharge.com/studio/html/ProgrammingTechn...SSolutions.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Joe
|
| Posted: 12/02/2004, 11:52 PM |
|
Thanks Peterr
I downloaded your trial with intentions of buying the program.
I installed the Task Manager program using the trial. Got a page not found error after spending more than an hour creating it.
It's not a program for someone with my experience and I can tell from just one support email that I would have serious difficulty getting someone to "hold my hand" while I learned how to use it.
It's a program for programmers.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/02/2004, 11:59 PM |
|
I agree that it is. However since you are not using this program for creating programs, you just need to open an example and press F9.
That will generate the code similar to what you downloaded from www.gotocode.com. So don't use this program for doing anything else than a 5 minute code output! 
The "page not found" error may not be related to CodeCharge Studio, just the way you try to run the PHP program that you published (installed).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Damian Hupfeld
|
| Posted: 12/03/2004, 12:01 AM |
|
Hiya Joe - I am NOT a pogrammer and I can make this program do some pretty cool stuff.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 12:09 AM |
|
Well, here you go. And I thought that it is only for programmers
However since we're on this topic, I'd recommend CodeCharge Studio to anyone with database experience since the correct database design is usually the key in creating a working application with any tool. Then programming experience indeed may not be necessary.
Back to the topic - if you don't want to program and just want to install one of the sample applications included with CCS, then all you need is to configure the database connection, press the F9 key and then know what to do with the PHP application that was created.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Joe
|
| Posted: 12/03/2004, 7:13 AM |
|
Thanks Peterr
Thanks Damien
That's why they invented IQ tests .... so they could sort out the smarter ones. I could probably learn it but it could take awhile.
|
|
|
|
cramblit
Posts: 4
|
| Posted: 12/03/2004, 7:00 PM |
|
Peterr
Any chance you would help someone less less gifted?
I took you advice Peterr and created the TaskMan. My host "for security reasons" does not permit any database connections so I have to figure out how to populate my database and manually configure this program.
I am used to importing SQL into these databases but usually there is a .txt or .sql file to import. There is no such file in the TaskMan directory.
There is a "db_mysql.php" file. Is that perhaps the database setup file?
I just need to the steps to get this thing running on the web.
I have all the files uploaded. I have a database created.
The instructions are no help with manually setting up anything. Evidently most hosts permit database connections. My host is really bad this way. PhP runs in safe mode. They don't allow SSH or Telnet access, etc. etc.
What files do I need to alter to connect with the database and install the correct tables and data into it?
Thanks very much for your help.
_________________
Joe |
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 10:09 PM |
|
That SQL dile file is in C:\Program Files\CodeChargeStudio\Examples\Intranet\Intranet_MySQL.sql
That's all that you should need to create the database for that example.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Joe
|
| Posted: 12/03/2004, 10:50 PM |
|
Can't import it or paste it .... all I get is access denied
#1044 - Access denied for user: 'maguire@localhost' to database 'intranet'
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 11:03 PM |
|
Not sure if I can help because this could be an issue that only your Web hosting company can resolve.
However, I suspect that your Web hosting account is setup for 1 database with name different than "intranet". In that case edit the above SQL file and change the database name:
===================
CREATE DATABASE IF NOT EXISTS intranet;
USE intranet;
===================
from intranet to some other database name that your Web hosting company created for you.
Or if you don't have any database created then you may need to ask your Web hosting company to create one for you.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Joe
|
| Posted: 12/03/2004, 11:06 PM |
|
I appears to be trying to create a new database called Intranet.
I am trying to upload this file using the method I have always used for uploading .sql files.
I have a database named taskman (maguire_taskman) would be the name. I am the user (maguire_joe).
I use PhP my Admin. Select the database. Select SQL. Browse for the "text file" and click GO.
|
|
|
|
Joe
|
| Posted: 12/03/2004, 11:11 PM |
|
Peterr...
I can create all the SQL databases I want with any name I want.
Should I create a a database named Intranet? The actual name always begins with the USER so it would be maguire_intranet
The problem seems to be that the .sql file is locked or something.
I did not see you message when I posted my last message.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 11:12 PM |
|
The .sql file cannot be locked. Just please edit it and change the database name there, or even completely remove "CREATE DATABASE IF NOT EXISTS intranet;" and just leave "USE database_name;"
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Joe
|
| Posted: 12/03/2004, 11:17 PM |
|
Changed the names in your .sql file to taskman.
Got the same message
#1044 - Access denied for user: 'maguire@localhost' to database 'taskman'
|
|
|
|
Joe
|
| Posted: 12/03/2004, 11:18 PM |
|
By the way I am SUPPOSED TO CREATE a database FIRST correct?
|
|
|
|
Damian Hupfeld
|
| Posted: 12/04/2004, 3:58 AM |
|
Ok, so now you are getting a permissions error. In your project settings you
specify a username, password and database. The username and password
specified here need to be setup and given permissions thru your PHPMyAdmin
application. Just like your database always starts with maguire_, your
username will also start with maguire_
regards
Damian Hupfeld
http://www.itng.com.au/services.php
"Joe" <Joe@forum.codecharge> wrote in message
news:541b1646d81ff0@news.codecharge.com...
> Changed the names in your .sql file to taskman.
>
> Got the same message
>
> #1044 - Access denied for user: 'maguire@localhost' to database 'taskman'
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Joe
|
| Posted: 12/04/2004, 8:55 AM |
|
Hi Damian
I am lost on this one. I am a reseller of hosting. I set up my own domains. I created this domain in my control panel. I did not yet BUY the domain name. The named servers are assigned when I create an account. The named servers are pointing to my DNS. The temporary address that I can use to set up and access these "temporary" domain
names is http://svr.edns1.com/~username
I just finished setting up a complete website with 5 sql databases (with a lot of uploaded .sql, csv and txt files) at one of these "temporary" addresses. The only difference is that this was an offically registered domain BUT the named servers were NOT pointing to my domain. After completing the website the named servers were changed to mine and everything worked fine.
My actual host tells me that "maguire" the user of this account cannot upload the sql file because my named servers are not pointing anywhere? That's because they looked for the www.domainname.com on who is and this name is not registered.
Basically what these people are telling me is that I have to BUY the domain name to upload to my "temporary" address.
I think they're nuts. Why could I upload to the other temporary address?
|
|
|
|
klwillis
Posts: 428
|
| Posted: 12/04/2004, 11:30 AM |
|
Since you're virtually hosting several domains, the domain name
might be required to resolve references to the host system (i.e. via FTP)
Does that sound reasonable? 
Quote Joe:
Hi Damian
I am lost on this one. I am a reseller of hosting. I set up my own domains. I created this domain in my control panel. I did not yet BUY the domain name. The named servers are assigned when I create an account. The named servers are pointing to my DNS. The temporary address that I can use to set up and access these "temporary" domain
names is http://svr.edns1.com/~username
I just finished setting up a complete website with 5 sql databases (with a lot of uploaded .sql, csv and txt files) at one of these "temporary" addresses. The only difference is that this was an offically registered domain BUT the named servers were NOT pointing to my domain. After completing the website the named servers were changed to mine and everything worked fine.
My actual host tells me that "maguire" the user of this account cannot upload the sql file because my named servers are not pointing anywhere? That's because they looked for the www.domainname.com on who is and this name is not registered.
Basically what these people are telling me is that I have to BUY the domain name to upload to my "temporary" address.
I think they're nuts. Why could I upload to the other temporary address?
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
Joe
|
| Posted: 12/04/2004, 3:32 PM |
|
OK ... got past the database upload. Had to take that name of the database out of the sql file. Got it all up there even though it did little good.
I edited this file to put in the right data
db_mysql.php
I edited a Common.php file to give the path
Attempting to open the Default.php page I get this....
------------------------------------------------------------------
Database error: Invalid SQL: SELECT TOP {SqlParam_endRecord} task_id, task_name, task_start_date, task_finish_date, status_name, project_name, priority_name, emp_name, type_name FROM ((((tasks LEFT JOIN statuses ON tasks.status_id = statuses.status_id) LEFT JOIN projects ON tasks.project_id = projects.project_id) LEFT JOIN priorities ON tasks.priority_id = priorities.priority_id) LEFT JOIN employees ON tasks.user_id_assign_to = employees.emp_id) INNER JOIN types ON tasks.type_id = types.type_id LIMIT 0,25
MySQL Error: 1064 (You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '{SqlParam_endRecord} task_id, task_name, task_start_date, task)
Session halted.
------------------------------------------------------------
When I open any of the HTML pages they're basically the template pages like in editing mode with all the field names appearing rather than data.
Any help appreciated.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/04/2004, 11:28 PM |
|
Looks you selected wrong database in CodeCharge Studio, in the Connection configuration -> Server settings. You need to select "MySQL" if working with MySQL.
However, I'm not sure if this will work now because you already edited Common.php. What kind of path did you edit there?
Anyway, select MySQL as your database and it may work.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Damian Hupfeld
|
| Posted: 12/05/2004, 3:19 AM |
|
Also,
Another workaround is to setup the database on a domain that you have
registerred. It is on the same server, so you point to localhost,
registerreddomain_database, registerreddomain_user and it will still work. I
did this once when I setup a demo site under www.nexthost.com.au/~northcot
and set the databases up under nexthost... anyways once I moved teh client
over to my server I never changed the databse connections cos they all still
worked... One day I'll get around to fixing it.
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
"klwillis" <klwillis@forum.codecharge> wrote in message
news:541b21046009cf@news.codecharge.com...
> Since you're virtually hosting several domains, the domain name
> might be required to resolve references to the host system (i.e. via FTP)
>
> Does that sound reasonable?
>
> Quote Joe:
> Hi Damian
>
> I am lost on this one. I am a reseller of hosting. I set up my own
> domains. I
> created this domain in my control panel. I did not yet BUY the domain
> name. The
> named servers are assigned when I create an account. The named servers are
> pointing to my DNS. The temporary address that I can use to set up and
> access
> these "temporary" domain
> names is http://svr.edns1.com/~username
>
> I just finished setting up a complete website with 5 sql databases (with a
> lot
> of uploaded .sql, csv and txt files) at one of these "temporary"
> addresses. The
> only difference is that this was an offically registered domain BUT the
> named
> servers were NOT pointing to my domain. After completing the website the
> named
> servers were changed to mine and everything worked fine.
>
> My actual host tells me that "maguire" the user of this account cannot
> upload
> the sql file because my named servers are not pointing anywhere? That's
> because
> they looked for the www.domainname.com on who is and this name is not
> registered.
>
> Basically what these people are telling me is that I have to BUY the
> domain
> name to upload to my "temporary" address.
>
> I think they're nuts. Why could I upload to the other temporary address?
>
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Joe
|
| Posted: 12/05/2004, 10:41 AM |
|
As my dear old dad used to say... "even a blind hog finds an ear of corn once in awhile".
I actually got this thing working! I basically did what you advised Damian more by accident than by following instructions.
After having the database online....and it failed. I went into the program, set all the settings to the existing database, unchecked that "TOP LEVEL or LEVEL TOP" checkbox (whatever that means ...it was all over the error messages?), FTP'd it directly to the site and much to my amazement ... it works! What does that LEVEL TOP statement mean?
Can't tell you how much I appreciated the support.
Now the challenge is moving a couple of columns and I have to insert another date column. I'm hoping I can handle that. I assume I can "very" carefully move the Project column to be first and the Tasks column to be second using the HTML template. I don't know if you can "order columns" in the program since it was a prebuilt example.
By the way does anyone know if there is any "limitation" on this example as to the number of records? I only have a couple hundred.
And, if you buy the program ... can you get rid of the "Code Charge" at the bottom?
Thank again. I can see that this is an amazing piece of software. I was really impressed with the FrontPage integration. That really helps with editing the HTML pages.
|
|
|
|
Damian Hupfeld
|
| Posted: 12/06/2004, 3:25 AM |
|
Hi Joe,
Before you edit anything in HTML mode try this - in CCS click your mouse
anywhere inside a column that you want to move left or right, and do
[Alt]+LArrow or [Alt]+RArrow and the columm will move left or Right. You can
do the same to rows using the up and down arrows.
Word of Warning -
CCS uses PHP TEMPLATES. The HTML and the PHP are seperated - unlike
traditional PHP programming.
Be very careful not to muck up the tags that look like this:
<!-- BEGIN Record new -->
<!-- BEGIN Error -->
These are very important...
regards
Damian Hupfeld
http://www.nexthost.com.au/services.php
"Joe" <Joe@forum.codecharge> wrote in message
news:541b3566707e12@news.codecharge.com...
> As my dear old dad used to say... "even a blind hog finds an ear of corn
> once in
> awhile".
>
> I actually got this thing working! I basically did what you advised
> Damian
> more by accident than by following instructions.
>
> After having the database online....and it failed. I went into the
> program, set
> all the settings to the existing database, unchecked that "TOP LEVEL or
> LEVEL
> TOP" checkbox (whatever that means ...it was all over the error
> messages?),
> FTP'd it directly to the site and much to my amazement ... it works! What
> does
> that LEVEL TOP statement mean?
>
> Can't tell you how much I appreciated the support.
>
> Now the challenge is moving a couple of columns and I have to insert
> another
> date column. I'm hoping I can handle that. I assume I can "very" carefully
> move
> the Project column to be first and the Tasks column to be second using the
> HTML
> template. I don't know if you can "order columns" in the program since it
> was a
> prebuilt example.
>
> By the way does anyone know if there is any "limitation" on this example
> as to
> the number of records? I only have a couple hundred.
>
> And, if you buy the program ... can you get rid of the "Code Charge" at
> the
> bottom?
>
> Thank again. I can see that this is an amazing piece of software. I was
> really
> impressed with the FrontPage integration. That really helps with editing
> the
> HTML pages.
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Damian Hupfeld
|
| Posted: 12/06/2004, 3:25 AM |
|
Err - yes of course the CodeCharge tags dissapear in the registerred
version.
"Joe" <Joe@forum.codecharge> wrote in message
news:541b3566707e12@news.codecharge.com...
> As my dear old dad used to say... "even a blind hog finds an ear of corn
> once in
> awhile".
>
> I actually got this thing working! I basically did what you advised
> Damian
> more by accident than by following instructions.
>
> After having the database online....and it failed. I went into the
> program, set
> all the settings to the existing database, unchecked that "TOP LEVEL or
> LEVEL
> TOP" checkbox (whatever that means ...it was all over the error
> messages?),
> FTP'd it directly to the site and much to my amazement ... it works! What
> does
> that LEVEL TOP statement mean?
>
> Can't tell you how much I appreciated the support.
>
> Now the challenge is moving a couple of columns and I have to insert
> another
> date column. I'm hoping I can handle that. I assume I can "very" carefully
> move
> the Project column to be first and the Tasks column to be second using the
> HTML
> template. I don't know if you can "order columns" in the program since it
> was a
> prebuilt example.
>
> By the way does anyone know if there is any "limitation" on this example
> as to
> the number of records? I only have a couple hundred.
>
> And, if you buy the program ... can you get rid of the "Code Charge" at
> the
> bottom?
>
> Thank again. I can see that this is an amazing piece of software. I was
> really
> impressed with the FrontPage integration. That really helps with editing
> the
> HTML pages.
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
