Hi guys i have a Jcow site which has a bug when i delete a members account it doesnt remove all posts from that member SO if they re-sign up with same username it errors
Now for once i know how to fix the problem with this:-
first: if you have deleted an user A and another user (or the same user) signs up again with the same username, got to phpMyAdmin --> sql tab and enter
SELECT `id`,`uri` FROM `jcow_pages` where `type` = 'u' order by `uri`[/CODE]
[i]by default the listing is limited to the first 30 rows, but you need all the rows.
if you have the same uri more than one time, remove the ones with the lowest id.[/i]
The problem i have is there are over a 10,000 entrys and doing it using the method above would take days how could i do it another way to spead things up?
Question
Craig Hopson
Hi guys i have a Jcow site which has a bug when i delete a members account it doesnt remove all posts from that member SO if they re-sign up with same username it errors
Now for once i know how to fix the problem with this:-
first: if you have deleted an user A and another user (or the same user) signs up again with the same username, got to phpMyAdmin --> sql tab and enter
[i]by default the listing is limited to the first 30 rows, but you need all the rows.
if you have the same uri more than one time, remove the ones with the lowest id.[/i]
The problem i have is there are over a 10,000 entrys and doing it using the method above would take days how could i do it another way to spead things up?
Link to comment
Share on other sites
0 answers to this question
Recommended Posts