WordPress.org

1. thisearly
   Member
   Posted 4 years ago #

   I installed wordpress a while back.. for some reason a lot of the tables were missing I hand made them but i keep getting this one, does anyone know what the structure should be like for it to work? (the links that is) also if anyone could post the source to go.php because i cant find it anywhere and its not in the wordpress zip file. thanks

   WordPress database error: [Unknown column 'link_clicks' in 'field list']
   SELECT link_clicks FROM wp_linkclicks WHERE link_url='http://neistat.com/pages/video_holding/goldfish_holding.htm'

   WordPress database error: [Unknown column 'link_clicks' in 'field list']
   SELECT link_clicks FROM wp_linkclicks WHERE link_url='http://digg.com/science/A_dead_goldfish_resurrected_using_Mountain_Dew,_and_a_9V_Battery.

2. Class
   Member
   Posted 4 years ago #

   Try creating a table 'wp_linkclicks'.
   I guess this is created by a plugin because I don't have that table.

3. thisearly
   Member
   Posted 4 years ago #

   i did..

4. ifelse
   Moderator
   Posted 4 years ago #

   This table is used by OZH's click counter plugin.

   For some reason, your table definition is incorrect. Use PHPMyAdmin and drop (i.e. remove) the wp_linkclicks table.

   You should then recreate it via the following piece of SQL:
   CREATE TABLE wp_linkclicks (
link_id INT NOT NULL AUTO_INCREMENT ,
link_url TEXT NOT NULL ,
link_clicks INT NOT NULL ,
link_date DATETIME NOT NULL ,
link_title TEXT NOT NULL ,
UNIQUE (
link_id
)
);

5. thisearly
   Member
   Posted 4 years ago #

   what about the source for go.php someone?

6. ifelse
   Moderator
   Posted 4 years ago #

   "what about the source for go.php someone?"

   Have you tried clicking the link I gave you?

   go.php is part of the click counter plugin developed by OZH and is not a core part of WP.

   The source code, usage and installation instructions can all be found on OZH's plugin page.

7. thisearly
   Member
   Posted 4 years ago #

   ill just write something myself. i hope i dont miss anything.

Topic Closed

This topic has been closed to new replies.