DELETE from my.account; DELETE from my.cq_user; DELETE from my.cq_eudemon; DELETE from my.cq_item; DELETE from my.cq_ad_log; DELETE from my.cq_announce; DELETE from my.cq_castle; DELETE from my.cq_castleitem; DELETE from my.cq_castlemap; DELETE from my.cq_deluser; DELETE from my.cq_donation_dynasort_rec; DELETE from my.cq_dyna_rank_rec; DELETE from my.cq_enemy; DELETE from my.cq_family; DELETE from my.cq_flower; DELETE from my.cq_friend; DELETE from my.cq_magic; DELETE from my.cq_partner; DELETE from my.cq_pk_bonus; DELETE from my.cq_shortcut_key; DELETE from my.cq_special_status; DELETE from my.cq_statistic; DELETE from my.cq_synattr; DELETE from my.cq_syndicate; DELETE from my.cq_trade; DELETE from my.cq_tutor; DELETE from my.cq_tutor_contributions; DELETE from my.e_money; Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999; Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;
just put this query dont added account at front cq_dynanpcQuote:
Thank you for your interest in the topic
Was
There are mistakes and I, a
ERROR 1146 : Table 'account.cq_dynanpc' doesn't exist
ERROR 1146 : Table 'account.cq_dynanpc' doesn't exist
What is the solution
Please attention
Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0 where ownerid > 9999; Update cq_dynanpc set datastr = 'None', owner_name = default_owner_name, ownerid = 0, price = initial_price, deposit = 0 where ownerid > 9999;