PDA

View Full Version : anyone else Getting Favorites errors ?


viralmeister
04-16-2006, 05:02 PM
simular to Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in public_html/dem/user.php on line 214

when adding favorites you'll get the errors the site prints favorite added succesfully
once you check your favorite they wont appear

Rosco404
04-19-2006, 09:26 AM
Yeah i get the same kind of error....

Ryan
04-19-2006, 10:34 AM
This will also be released in the next update. If you want a temporary solution do this:
Run this query in phpMyAdmin:
ALTER TABLE `favorites` CHANGE `video_id` `file_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

hoangism
06-01-2006, 06:46 AM
I think I see where the error was. In the user.php file, the code refers to a file_id in the MySQL database. However, when you go into phpMyAdmin in the favorites table, I noticed there was only a favorite_id, user_id, and video_id. To fix the problem, I added the file_id query (highlight on screenshot) and set the values to what Ryan had posted. Problem fixed. I can add favorites now.

http://www.ohshitz.com/thumb.gif

Ryan
06-01-2006, 08:46 AM
Actually, you need to rename favorite_id to file_id and that will fix your issue.