ansonphong / postworld

Wordpress Theme Development Framework
GNU General Public License v2.0
7 stars 0 forks source link

Voting Error After DB Import #76

Closed ansonphong closed 10 years ago

ansonphong commented 10 years ago

When running set_points or set_post_points this error occurs

Run

echo json_encode (set_points( "post", 133925, "5" ));

Output

WordPress database error: [The user specified as a definer ('admin_staging'@'%') does not exist]
update wp_postworld_post_points set post_points=5 where post_id=133925 and user_id=1

{"point_type":"post","user_id":1,"id":133925,"points_added":2,"points_total":"3"}

It is solved by disabling and then re-activating Postworld plugin. That user 'admin_staging' exists only on the server that Postworld was activated on and then the DB was exported.

How can we make this so that it's not linked to the user who activated Postworld?