I have a sub which select 2 values from the user table changes the values
then does an update to return the changed values to the table.
This was working. I rebooted my machine now it is not working.
These 2 select statements bring return the right values.
my $current_rating = $ut->select(['DP_ImageRating'],{ Username => $cand_user })->fetchrow_array;
my $votes = $ut->select(['DP_ImageVotes'],{ Username => $cand_user })->fetchrow_array;
Then I display the values to the screen and run some math on the values then perform this update statement:
$ut->update( {DP_ImageRating => $new_average,
DP_ImageVotes => $votes},
{ Username => $cand_user});
The update does not update the values.
I tried removing the plugin...which delete the columns from the table. Resyncing the database. Reinstalling.
No joy.
I also tried:
echo > lsql_Users.def
then resyncing..... this fixed the last update problem I had... no joy.
The irritating thing is I can update all the other fields in the table.
Any ideas would be appreciated.
Gordon
=================
www.iuni.com - Custom Coding and Plugins
YouPlusMe.com - For a good time
then does an update to return the changed values to the table.
This was working. I rebooted my machine now it is not working.
These 2 select statements bring return the right values.
my $current_rating = $ut->select(['DP_ImageRating'],{ Username => $cand_user })->fetchrow_array;
my $votes = $ut->select(['DP_ImageVotes'],{ Username => $cand_user })->fetchrow_array;
Then I display the values to the screen and run some math on the values then perform this update statement:
$ut->update( {DP_ImageRating => $new_average,
DP_ImageVotes => $votes},
{ Username => $cand_user});
The update does not update the values.
I tried removing the plugin...which delete the columns from the table. Resyncing the database. Reinstalling.
No joy.
I also tried:
echo > lsql_Users.def
then resyncing..... this fixed the last update problem I had... no joy.
The irritating thing is I can update all the other fields in the table.
Any ideas would be appreciated.
Gordon
=================
www.iuni.com - Custom Coding and Plugins
YouPlusMe.com - For a good time