Software error:
Can't call method "prepare" without a package or object reference at database_MySQL.pl line 266.

Can some one assist me in correcting this error.

Thank you
SandraR

Did you run create.cgi already to create the tables?

Did you fill out the MySQL variables correctly?

Did you run create.cgi already to create the tables?
Yes and deleted it as directed.

Did you fill out the MySQL variables correctly?
YES - I can see the tables create.cgi created.

TABLE ACTION RECORDS
ads Browse Select Properties Insert Drop Empty 0
extra Browse Select Properties Insert Drop Empty 0
feed Browse Select Properties Insert Drop Empty 0
registration Browse Select Properties Insert Drop Empty 1 (me Admin)
temp Browse Select Properties Insert Drop Empty 0
tempads Browse Select Properties Insert Drop Empty 0

What do you have for your @categories array?

I left them alone (default) as I was simply testing the program to ensure it worked first.

@categories = (
["Automotive", "Cars", "Trucks", "Motorcycles"],
["Computers", "Desktops", "Laptops", "Servers", "Accessories"],
["Home And Garden", "Tools", "Seeds", "Lawn", "Misc"],
["Electronics", "Television", "Stereos", "Home Theatre"],
["Employment", "Help Wanted", "Services", "Temp Work"],
);

Do you have a link where I can see this in action?

..........

I will need access to your server in order to see what is the problem. You can send the details via our contact form on our site.

Is there another way to work through this?

I am not comfortable with letting anyone on my server; all my other databases are working fine without a hitch.


Below are the table properties if that is what you are looking for. I did notice there is not a single incrimental option? how does it label/ID them?


TABLE ACTION RECORDS
Field Type Null Key Default

ads

id int(11) 0
name text YES
category text YES
description text YES
days text YES
title text YES
price text YES
quantity text YES
payment text YES
delivery text YES
template text YES
picture longblob YES



extra

id varchar(255)
bold int(11) YES
featured int(11) YES


feed

id varchar(255)
userposted text YES
rating int(11) YES
comment text YES



registration

id varchar(255) PRI
password text YES
email text YES
address text YES
address2 text YES
city text YES
country text YES
zip text YES
phone text YES
verify int(11) YES



temp

id varchar(255)
picture longblob YES



tempads

id int(11) 0
name text YES
category text YES
description text YES
days text YES
title text YES
price text YES
quantity text YES
payment text YES
delivery text YES
template text YES
bold int(11) YES
featured int(11) YES
picture longblob YES

I have to see what is going on on the server side, I am not sure how else I can help you unless I can see.

You need to tell me what you need to look at.

If all you want is FTP access to that particulare doamin - I can do that.


I cannot let you in the complete server unless you are willing to sign an agreement holding you and your company liable for any damages that may take place while you are in my server.

FTP is all I need.

I will utilize the contact form to send you the info you need.

Thank you

Contact message sent with FTP information

I could find no reason why this would be happening, but I changed some code that does the user count and it worked fine. For some reason, your MySQL server does not like the selectrow_array method in DBI, so I changed the sub in the database file called User_Count to this:

### Count Users
sub User_Count {
my $db = &dbconnect;
my $k;
my $rows = 0;
my $dbh=$db->prepare("SELECT id FROM registration") or &oops("$! Database Error DBI: $DBI::errstr");
$dbh->execute() or &oops("$! Cannot connect to registration database DBI: $DBI::errstr");
while (($k) = $dbh->fetchrow_array()) {
$rows++;
}
dbdisconnect($db);
$rows;
}

All appears to be working fine now.

Thank you,

Its working FINE! :p