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 -> CodeChargeStudio.Discussion

 Lost, Lost!!!

Print topic Send  topic

Author Message
ferg
Posted: 11/06/2003, 4:35 AM

G'Day All,
I published by project from a WIN2K box to a RedHat box ok. Good!!
When I browse to my page http://192.168.131.31/index.php that's ok also.
I enter usernas and pwd and then I get:
Database error: Invalid SQL: SELECT user_id, group_id FROM users WHERE
user_login='admin' AND user_password='admin'
MySQL Error: 1146 (Table 'prime.users' doesn't exist)
Session halted.

How do I fix this?
Thanks much

Mike R.
Posted: 11/06/2003, 5:20 AM

Check the obvious....MySQL is installed on your RH box. MySQL running on
your RH box. MySQL database has a table called 'users'.

You may be working locally with MSAccess on your Win2K machine, but the
server will want a similar table structure in MySQL. If you haven't
already:

1. Get EMS MySQL Manager from www.ems-hitech.com.
2. Get Access to MySQL converter from www.convert-in.com.
3. Find where the Access database that you're using locally is, and convert
it to MySQL and push it over.

Enjoy.

"ferg" <ferguson@eastsidemiami.com> wrote in message
news:bodf5q$31h$1@news.codecharge.com...
> G'Day All,
> I published by project from a WIN2K box to a RedHat box ok. Good!!
> When I browse to my page http://192.168.131.31/index.php that's ok also.
> I enter usernas and pwd and then I get:
> Database error: Invalid SQL: SELECT user_id, group_id FROM users WHERE
> user_login='admin' AND user_password='admin'
> MySQL Error: 1146 (Table 'prime.users' doesn't exist)
> Session halted.
>
> How do I fix this?
> Thanks much
>
>

ferg
Posted: 11/06/2003, 5:28 AM

Mike R,
Thanks
"Mike R." <mike@datadoit.com> wrote in message
news:bodhrl$88j$1@news.codecharge.com...
> Check the obvious....MySQL is installed on your RH box. MySQL running on
> your RH box. MySQL database has a table called 'users'.
>
> You may be working locally with MSAccess on your Win2K machine, but the
> server will want a similar table structure in MySQL. If you haven't
> already:
>
> 1. Get EMS MySQL Manager from www.ems-hitech.com.
> 2. Get Access to MySQL converter from www.convert-in.com.
> 3. Find where the Access database that you're using locally is, and
convert
> it to MySQL and push it over.
>
> Enjoy.
>
> "ferg" <ferguson@eastsidemiami.com> wrote in message
>news:bodf5q$31h$1@news.codecharge.com...
> > G'Day All,
> > I published by project from a WIN2K box to a RedHat box ok. Good!!
> > When I browse to my page http://192.168.131.31/index.php that's ok also.
> > I enter usernas and pwd and then I get:
> > Database error: Invalid SQL: SELECT user_id, group_id FROM users WHERE
> > user_login='admin' AND user_password='admin'
> > MySQL Error: 1146 (Table 'prime.users' doesn't exist)
> > Session halted.
> >
> > How do I fix this?
> > Thanks much
> >
> >
>
>

ferg
Posted: 11/06/2003, 7:24 AM

Ok. I see what my problem is. CAn you help me any way?
Prior to CodeCharge I had manually created a database named prime and was
working on it. With the purchase of CodeCharge I started all over and even
created a new database name prime on the WIN2K box.

Just now I dropped the old prime database. How do I get CodeCharge to move
the new and correct database from the WIN2K box to the RedHat box and where
on the RedHat box does the database reside? Thanks




"Mike R." <mike@datadoit.com> wrote in message
news:bodhrl$88j$1@news.codecharge.com...
> Check the obvious....MySQL is installed on your RH box. MySQL running on
> your RH box. MySQL database has a table called 'users'.
>
> You may be working locally with MSAccess on your Win2K machine, but the
> server will want a similar table structure in MySQL. If you haven't
> already:
>
> 1. Get EMS MySQL Manager from www.ems-hitech.com.
> 2. Get Access to MySQL converter from www.convert-in.com.
> 3. Find where the Access database that you're using locally is, and
convert
> it to MySQL and push it over.
>
> Enjoy.
>
> "ferg" <ferguson@eastsidemiami.com> wrote in message
>news:bodf5q$31h$1@news.codecharge.com...
> > G'Day All,
> > I published by project from a WIN2K box to a RedHat box ok. Good!!
> > When I browse to my page http://192.168.131.31/index.php that's ok also.
> > I enter usernas and pwd and then I get:
> > Database error: Invalid SQL: SELECT user_id, group_id FROM users WHERE
> > user_login='admin' AND user_password='admin'
> > MySQL Error: 1146 (Table 'prime.users' doesn't exist)
> > Session halted.
> >
> > How do I fix this?
> > Thanks much
> >
> >
>
>

Ed Moss
Posted: 11/06/2003, 11:19 AM

I purchased CCS last week, and have been having a number of issues with
connection strings and db placement....

I use ASP, so my solutions may be a bit different than yours, but the
concepts are similar.

Here's my take on your situation.... Unlike many similar products
(ASPrunner, DB2ASP, etc.) CCS does not automatically move your db into the
proper place. Additionally, it will not automatically create the proper
connection string unless you provide the correct path information in Project
Settings/Publishing tab/Server.

I handled this as follows:
1. To determine the correct server path, contact your ISP, then try to
connect with an ftp client to verify that it is correct, and that the
permissions are set so you can access and write to the directory.

2. FTP your db from your local server, up to the live server, into the
correct location.
3. After publishing with CCS, use your ftp client to verify that the files
are where they should be, then be prepared to manually change the server
deployed common.asp (php?) page (which is where the connection string is
located) if CCS doesn't map it properly.

4. Be prepared! When I change my publishing settings from ftp back to
local/network, my common.asp page does not change, so my local site attempts
to connect to the remote db... I have a call in to the owner of Yes
SOftware, because I've been banging my head against the wall with all this
"stuff" since I signed on last Friday....

Great product..... I hope they can get the Docs and support up to the same
level!!!!

Regards,

Ed Moss


Kevin
Posted: 11/07/2003, 12:47 AM

--snip
Quick overview:
CCS requires two database connections, one for design and one for live page.
The first connection is an ODBC type connector that requires you to build an
ODBC connection on your local machine pointing to your database. The second
or 'server' connection can be an ODBC type connection or an RDBMS library
connection. I've requested a setting to allow a single library connection
for both Design and Live Page, when I use ODBC to my SQL server I have to
create two users: admin@localhost and for the ODBC connector
admin@computername.mshome.net -- having both Design and Live Page using the
same database saves me from having to keep two databases in sync.
That being said, CCS does not create or migrate data structures or data, you
do. Down load PHPMyAdmin http://www.phpmyadmin.net/ and download WEBMIN for
your RH box. These tools are what you'll need to manage MySQL..

We create everything local with two Linux servers, one a WEB server and one
a Database server, we 'publish' to the WEB server using a SMB share point.
We move files into production with FPT after passing QA. I tried CCS FTP, to
slow and costly, we pay for bandwidth.

ferg
Posted: 11/10/2003, 7:07 AM

Ed Moss and Kevin,

Thanks very much for your feedback. I tried your steps and now I am ok.
Are any of your guys professional CCS developers?...meaning you work for
pay?
I am looking for help beyond where I am.


"Kevin" <kevin@talkcycle.com> wrote in message
news:bofm7g$f6u$1@news.codecharge.com...
> --snip
> Quick overview:
> CCS requires two database connections, one for design and one for live
page.
> The first connection is an ODBC type connector that requires you to build
an
> ODBC connection on your local machine pointing to your database. The
second
> or 'server' connection can be an ODBC type connection or an RDBMS library
> connection. I've requested a setting to allow a single library connection
> for both Design and Live Page, when I use ODBC to my SQL server I have to
> create two users: admin@localhost and for the ODBC connector
>admin@computername.mshome.net -- having both Design and Live Page using
the
> same database saves me from having to keep two databases in sync.
> That being said, CCS does not create or migrate data structures or data,
you
> do. Down load PHPMyAdmin http://www.phpmyadmin.net/ and download WEBMIN
for
> your RH box. These tools are what you'll need to manage MySQL..
>
> We create everything local with two Linux servers, one a WEB server and
one
> a Database server, we 'publish' to the WEB server using a SMB share point.
> We move files into production with FPT after passing QA. I tried CCS FTP,
to
> slow and costly, we pay for bandwidth.
>
>

Kevin
Posted: 11/23/2003, 8:58 PM

I create custom E-commerce sites for a living - What do you need?

"ferg" <ferguson@eastsidemiami.com> wrote in message
news:boo9jh$6gm$1@news.codecharge.com...
> Ed Moss and Kevin,
>
> Thanks very much for your feedback. I tried your steps and now I am ok.
> Are any of your guys professional CCS developers?...meaning you work for
> pay?
> I am looking for help beyond where I am.
>
>
> "Kevin" <kevin@talkcycle.com> wrote in message
>news:bofm7g$f6u$1@news.codecharge.com...
> > --snip
> > Quick overview:
> > CCS requires two database connections, one for design and one for live
> page.
> > The first connection is an ODBC type connector that requires you to
build
> an
> > ODBC connection on your local machine pointing to your database. The
> second
> > or 'server' connection can be an ODBC type connection or an RDBMS
library
> > connection. I've requested a setting to allow a single library
connection
> > for both Design and Live Page, when I use ODBC to my SQL server I have
to
> > create two users: admin@localhost and for the ODBC connector
> >admin@computername.mshome.net -- having both Design and Live Page using
> the
> > same database saves me from having to keep two databases in sync.
> > That being said, CCS does not create or migrate data structures or data,
> you
> > do. Down load PHPMyAdmin http://www.phpmyadmin.net/ and download WEBMIN
> for
> > your RH box. These tools are what you'll need to manage MySQL..
> >
> > We create everything local with two Linux servers, one a WEB server and
> one
> > a Database server, we 'publish' to the WEB server using a SMB share
point.
> > We move files into production with FPT after passing QA. I tried CCS
FTP,
> to
> > slow and costly, we pay for bandwidth.
> >
> >
>
>


   


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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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