[MOD] Votes saved in DB

[Fryz]

hallo,

ich hab das mod (version a) insalliert und bekomme beim abstimmen folgenden fehler:

DB Error: Bad SQL Query: SELECT user_id, image_id, vote FROM 4images_voted WHERE image_id = 2329 AND user_id = 1
Unknown column 'user_id' in 'field list'


kann mir da mal jemand helfen?

danke

[V@no]

huh? and what fields are in your 4images_voted table? Hope you didnt change anything that were not supposed to...

[Fryz]

Thanx for answering.
I didn't change anything that is not supposed to be changed, I made everything as advised. look---> http://fryz.fr.funpic.de/4images/statistics.php

In the moment i vote for a photo in my gallery, the following hint appears:


DB Error: Bad SQL Query: SELECT user_id, image_id, vote FROM 4images_voted WHERE image_id = 2354 AND user_id = 2
Unknown column 'user_id' in 'field list'

DB Error: Bad SQL Query: INSERT INTO 4images_voted (user_id, image_id, vote) VALUES (2, 2354, 5)
Unknown column 'user_id' in 'field list'

[V@no]

So, what are the fields in your 4images_voted table?

[Fryz]

VOTED_TABLE    INT    11    -----     UNSIGNED     not null     0     -----


you mean this?

[V@no]

No, I mean this something like this:[qcode]CREATE TABLE `4images_voted` (
  `id` mediumint(8) NOT NULL auto_increment,
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `image_id` mediumint(8) unsigned NOT NULL default '0',
  `vote` int(2) unsigned NOT NULL default '0',
  `date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`),
  KEY `image_id` (`image_id`)
) ENGINE=MyISAM;[/qcode](this is how it looks like when you export it in phpmyadmin)

or from mysql shell itself:[qcode]mysql> SHOW columns FROM 4images_voted;
+----------+-----------------------+------+-----+---------+----------------+
| Field    | Type                  | Null | Key | Default | Extra          |
+----------+-----------------------+------+-----+---------+----------------+
| id       | mediumint(8)          |      | PRI | NULL    | auto_increment |
| user_id  | mediumint(8) unsigned |      | MUL | 0       |                |
| image_id | mediumint(8) unsigned |      | MUL | 0       |                |
| vote     | int(2) unsigned       |      |     | 0       |                |
| date     | int(11)               |      |     | 0       |                |
+----------+-----------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)[/qcode]

I think you should delete the table and run the installer again.

[mstgokcen]

I have the same code like :

DB Error: Bad SQL Query: INSERT INTO 4images_voted (user_id, image_id, vote) VALUES (, 12, 3)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 12, 3)' at line 4
 

and my table on myphpadmin is like:

----------------------------------------------------

#
# Tablo yapısı : `4images_voted`
#

DROP TABLE IF EXISTS `4images_voted`;
CREATE TABLE `4images_voted` (
  `user_id` mediumint( unsigned NOT NULL default '0',
  `image_id` mediumint( unsigned NOT NULL default '0',
  `vote` int(2) unsigned NOT NULL default '0',
  KEY `user_id` (`user_id`),
  KEY `image_id` (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;




whats wrong?

NOTE: I had already installed "more and more statistics MOD" before this mod.

[mstgokcen]

In the first page you say:



Open /includes/functions.php

Step 2.2
Find next:

Code: [Select]

    $sql = "UPDATE ".IMAGES_TABLE."
            SET image_votes = ($image_votes + 1), image_rating = '$new_rating'Add before:

Code: [Select]

if ($user_info[$user_table_fields['user_id']] != GUEST) {
  $sql = "INSERT INTO ".VOTED_TABLE."
          (user_id, image_id, vote)
          VALUES
          (".$user_info[$user_table_fields['user_id']].", ".$image_id.", ".$rating.")";
  $site_db->query($sql);
}


but in my function.php I coudnt find the code you told but I have this code instead

$sql = "UPDATE ".IMAGES_TABLE."
            SET image_votes = ($old_votes + 1), image_rating = '$new_rating'
            WHERE image_id = $image_id";
    $site_db->query($sql);




why my code is different

should I follow the version B?

[myr2904]

After i vote..apear this:


DB Error: Bad SQL Query: INSERT INTO 4images_voted (user_id, image_id, vote) VALUES (, 19, 1)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 19, 1)' at line 4

Why?

[V@no]

Sorry, redo steps 1 and 2.2

[myr2904]

but in my function.php I coudnt find the code you told but I have this code instead

$sql = "UPDATE ".IMAGES_TABLE."
            SET image_votes = ($old_votes + 1), image_rating = '$new_rating'
            WHERE image_id = $image_id";
    $site_db->query($sql);




why my code is different

should I follow the version B?

I have the same problem

[V@no]

yes, insert the new code above

Code: [Select]

$sql = "UPDATE ".IMAGES_TABLE."
            SET image_votes = ($old_votes + 1), image_rating = '$new_rating'

P.S. I've updated the original post, thanks.

[myr2904]

function update_image_rating($image_id, $rating) {
  global $site_db, $user_info;
  $sql = "SELECT cat_id, image_votes, image_rating
          FROM ".IMAGES_TABLE."
          WHERE image_id = $image_id";
  $image_row = $site_db->query_firstrow($sql);
  if (check_permission("auth_vote", $image_row['cat_id'])) {
    $old_votes = $image_row['image_votes'];
    $old_rating = $image_row['image_rating'];
    $new_rating = (($old_rating * $old_votes) + $rating) / ($old_votes + 1);
    $new_rating = sprintf("%.2f", $new_rating);
    $sql = "UPDATE ".IMAGES_TABLE."
            SET image_votes = ($old_votes + 1), image_rating = '$new_rating'



/*line 555 >>>*/            if ($user_info[$user_table_fields['user_id']] != GUEST) {
  $sql = "INSERT INTO ".VOTED_TABLE."
          (user_id, image_id, vote)
          VALUES
          (".$user_info[$user_table_fields['user_id']].", ".$image_id.", ".$rating.")";
  $site_db->query($sql);
}   


         
            WHERE image_id = $image_id";
    $site_db->query($sql);
  }
}



The code it's ok?

because i have a problem >>>> Parse error: syntax error, unexpected '[', expecting ']' in /home/etop100/public_html/concurs/includes/functions.php on line 555

[V@no]

ABOVE (before), not BELOW (after)

[myr2904]

ups ... thx

but i steel have this error:

Code: [Select]

DB Error: Bad SQL Query: INSERT INTO 4images_voted (user_id, image_id, vote) VALUES (, 19, 1)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 19, 1)' at line 4Version 1.7.1