CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Getting example project to work

Print topic Send  topic

Author Message
whiter
Posted: 05/06/2003, 5:15 AM

Hi,
I'm just starting to go through the CodeCharge tutorial, and one of the first things it suggests I do is to test out the CodeCharge setup by creating one of the sample projects supplied - I've chosen the employee database.

I am using WinXP, Apache [local] web server, PHP (already tested) and MySQL (tested via MySQL Control Center), plus CodeCharge Studio 2.0.5.6.

I changed the "settings" of the sample project to connect to MySQL etc. (*I THINK!* .... can't show them here as I can't paste in the config windows)

The application generates *apparently* ok, and appears via a local URL http://localhost/CodeCharge/employees/Default.html

However, the content is wrong, and links etc. goto non-existent pages.

I see (aplolgies for distortion, can't paste image in here):-

{Header}
Employee Search {Error} Advanced Search

Employee Directory Name Title Department Work Phone Email
{name} {title} {dep_id} {work_phone} {email}
{Alt_name} {Alt_title} {Alt_dep_id} {Alt_work_phone} {Alt_email}

No records
{Page_Number} of {Total_Pages}


Also, get 404 error on all links????

Any idea where this has gone wrong? Any critical setup steps I've missed or obviously got wrong ????

I can email images of "settings" config windows, plus what I'm actually seeing on the Default.html page to anyone to help show clearly the problem.

Thanks in advance

Richard

whiter@mailops.com








whiter
Posted: 05/06/2003, 7:33 AM

Sorry about previous msg - was in a hurry there.

The actual problem is when I try to display the Default.php file in the sample solution "employee directory".

I get a screen full of error messages about the generated code.


Are these PHP implementation errors (or incomplete configuration?)?
(rather than codecharge issues?)

I've put the first few lines on Default.php below the error messages.
-----------------------------------------------------------------
Warning: main(./Template.php) [function.main]: failed to create stream: No such file or directory in C:\...\...\codecharge\employees\Default.php on line 5

Warning: main() [function.main]: Failed opening './Template.php' for inclusion (include_path='.;c:\php4\pear') in C:\...\...\codecharge\employees\Default.php on line 5

Warning: main(./Sorter.php) [function.main]: failed to create stream: No such file or directory in C:\...\...\codecharge\employees\Default.php on line 6

Warning: main() [function.main]: Failed opening './Sorter.php' for inclusion (include_path='.;c:\php4\pear') in C:\...\...\codecharge\employees\Default.php on line 6

Warning: main(./Navigator.php) [function.main]: failed to create stream: No such file or directory in C:\...\...\codecharge\employees\Default.php on line 7

Warning: main() [function.main]: Failed opening './Navigator.php' for inclusion (include_path='.;c:\php4\pear') in C:\...\...\codecharge\employees\Default.php on line 7

Fatal error: Cannot instantiate non-existent class: clssorter in C:\...\...\codecharge\employees\Default.php on line 227
-----------------------------------------------------------------

<?php
//Include Common Files @1-5471E0F2
define("RelativePath", ".");
include(RelativePath . "/Common.php");
include(RelativePath . "/Template.php");
include(RelativePath . "/Sorter.php");
include(RelativePath . "/Navigator.php");
//End Include Common Files

RipCurl
Posted: 05/06/2003, 2:10 PM


You are jumping rivers when you should be stepping over puddles.
For the benefit of the doubt, you do have your MySQL running, and your database for employee directory already as a db within MySQL? If not, first make sure you set this up.

Create a MySQL DB names empdir
Use the sample SQL under CodeCharge/Examples/EmpDIr/SQL folder wherever your Codecharge program is installed.


Start with the online tutorial for BugTracking
http://download2.codecharge.com/support/Fast_Track_Tuto...df?product_id=1

If you want to continue with the Employee Directory example:

1. Go to your windows explorer and locate your apache > Htdocs folder. Make sure your have a CodeCharge/employees directory within.

2. Open your CC project and make sure:
a) General settings is set to what you like (seeing you're working with php+templates.
b) Publishing settings is set to local/network; Output code path (use the little folder to locate the folder in step 1.
c) Databases . Make sure you set up your connection to YOUR database (ie empdir) . If you haven't set up your DSN to your DB, then you can do this through CC. Set it to DSN for type, click on the yellow cylinder next to the field Data Source Name. Choose ADD under the User Data Sources > Choose MySQL from the list > Give your DSN a name (ie Employee) > fill in your mysql host (ie localhost) username (ie root) password (ie root) and your DB name (ie empdir) Click ok until you're back to the CC screen.

Security/Pages/Files should all be fine.

If all of these are setup , you have the sample sql dump in yoru DB, you can right off go to the GENERATOR section and hit Generate. This should publish all your pages to apache > htdocs > Codecharge > employees

To access your sample, goto your browsre and type in http://localhost/Codecharge/employees/default.php (not .html . these are your template files)


I suggest you walk on over to http://support.codecharge.com/tutorials.asp?product_id=1 to get started

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.