Well I have FreeBSD 4.2 and MySQL 3.23.33 running on localhost.
I use PhpMyAdmin to do any modifications. I did make the nameserver changes
in:
Database ShoppingCart - table stores
Database mysql - table db
Database mysql - table host
Database mysql - table user
I reset mysql and apache and still get Internal Server errors and here's
whats in the logs:
DBI->connect(toyotaecommerce:ns1.cityscope.net) failed: Access denied for
user: '[EMAIL PROTECTED]' (Using password: YES) at
/usr/local/www/data/cart/toyotaecommerce.cgi line 33
[Wed Jul 24 07:44:37 2002] [error] Can't call method "prepare" on an
undefined value at
/usr/local/lib/perl5/site_perl/5.005/CityScope/ShoppingCart.pm line 267.
this is line 33...
my $dbh =
DBI->connect("DBI:mysql:$toyotaecommerce{dbname}:$toyotaecommerce{dbhostname
}", $toyotaecommerce{dbuser}, $toyotaecomm
this is line 267
sub getIDdb {
my ($self, $dbh, $id, $store) = @_;
my ($check, $sth, @cart);
$check = 'select * from carts where(id = "' . $id . '");';
$sth = $dbh->prepare($check) or $self->Error('Could not prepare
select statement in sub getIDdb(); ' . $dbh->errstr);
Ingrid Kast Fuller
CityScope Net
3910 Fairmont Parkway #264
Pasadena, TX 77504-3066
(713) 477-6161
-----Original Message-----
From: chuck amadi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 7:14 AM
To: Ingrid Kast Fuller
Subject: Re: MySql 3.23 to version 4 upgrade
Ingrid Kast Fuller wrote:
>Hey Chuck, since you're up at this time, could I ask you for some MySQL
>help?
>I changed my name server names and IP addresses and having trouble getting
>them put in the database and my ecommerce sites are currently down. I have
>phpAdmin and went into one file and changed all the cs1.cityscope.net to
>ns1.cityscope.net but that didn't help. Where else would I change the info
>so the database will work. I keep getting "Internal Server Error"'s?
>Your help is appreciated.
>
>Ingrid Kast Fuller
>CityScope Net
>3910 Fairmont Parkway #264
>Pasadena, TX 77504-3066
>(713) 477-6161
>
>-----Original Message-----
>From: chuck amadi [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, July 24, 2002 3:33 AM
>To: mysql
>Subject: MySql 3.23 to version 4 upgrade
>
>
>Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any
>issues that should be addressed ie uninstall v3 prior to installing v4
>or can i just install over v3.
>
>Any suggested sites' ,FAQ regarding my question.
>
>--
>Regards
>
>Chuck Amadi
>ICT Dept Systems Programmer
>Rhaglenydd Systemau Adran ICT
>
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
Hi There Plz could explain what O/s and Server as I'm currently running
Apache v1 with PhpMyAdmin (maintenace purposes only) running on my Win
Box 98 for testing & development etc.
Work stuff is linux based environment & System Administrator sorts that
stuff out.
Thus i edited C:\Program Files \ Apache Group\Apache\Conf\httpd.conf and
look for # ServerName new.host.name
and add your ipAddress thus if your'e running virutally hosts go to the
bottom - #NameVirtualHost
<VirtualHost>
ServerName
DocumentRoot
ServerName
Also check your'e WebAppConnection Conn Warp yourHost:8008 (your port)
Best thing to do is C & P to list altering of cause your ipAddress details.
I hope this helps or someone with more exp continue's the thread.
--
Regards
Chuck Amadi
ICT Dept Systems Programmer
Rhaglenydd Systemau Adran ICT
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
