Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

updating database but update.pl script fails? see attached files

I have an update.pl script   it downloads data from the mls and puts in db on server but I am now getiting error.  DBD::mysql::st execute failed: Unknown column 'photos_count' in 'field list' at                                               ./load_photos.pl line 11
load_photos.pl = 
#!/usr/bin/perl
 
use DBI;
chdir('/home/httpd/vhosts/xxxx.com/subdomains/lasvegas/httpdocs/mls');
my $dbh = DBI->connect ("DBI:mysql:lasvegas", 'lasvegas', 'monday');
my @rows = `cat photo_count.txt`;
foreach my $row (@rows) {
 chomp $row;
# print "$row\n";
 $sth = $dbh->prepare($row);
 $sth->execute;
 $sth->finish if ($sth);
}
$dbh->disconnect;
  line 11=  $sth->execute;

Open in new window

load-photos.txt
update.txt
lasvegasfixsql.txt
0
webguy62
Asked:
webguy62
1 Solution
 
Adam314Commented:
In your photo_count.txt file, you have a SQL statement that refers to the field photos_count in some table, but that table in your database does not have a photos_count field.
0
 
webguy62Author Commented:
I added new field to table class_5= photos_count then ran update .pl  it seems to be working now....  thanks big time
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now