Page 3 of 3
Re: Tutorial for shop-module and hack to use shop in 1.3.3
Posted: Fri 7. Mar 2008, 21:14
by nebenaube
Kulinarisk wrote:Another stupid question. Playing around with the backend - I have deleted some categories (since the hierarchy is alphabetical) and somehow it hangs in sql when I reintroduce the same name. How do I clean the cache in mysql? Or is it a bug?
You can always drop and then reinstall the tables;
Re: Tutorial for shop-module and hack to use shop in 1.3.3
Posted: Fri 7. Mar 2008, 22:51
by flip-flop
Hi,
there are old entrys inside your db.
Please run this snippet using phpMyAdmin in SQL:
For deleted articles:
Code: Select all
DELETE FROM phpwcms_article WHERE article_deleted=9;
DELETE FROM phpwcms_articlecontent WHERE acontent_trash=9;
For deleted structure names:
Code: Select all
DELETE FROM phpwcms_articlecat WHERE acat_trash=9;
For deleted files/pictures (only after you have cleared the trash can in filemanager and doing Admin -> remove delete files :
Code: Select all
DELETE FROM phpwcms_file WHERE f_trash=8;
Regards Knut
Re: Tutorial for shop-module and hack to use shop in 1.3.3
Posted: Mon 10. Mar 2008, 15:32
by Kulinarisk
flip-flop wrote:For deleted files/pictures (only after you have cleared the trash can in filemanager and doing Admin -> remove delete files :
Code: Select all
DELETE FROM phpwcms_file WHERE f_trash=8;
Regards Knut
Do I do this in phpmysql?
I'm not very fluent in phpmysql
Re: Tutorial for shop-module and hack to use shop in 1.3.3
Posted: Mon 10. Mar 2008, 15:48
by flip-flop
phpMyAdmin
Re: Tutorial for shop-module and hack to use shop in 1.3.3
Posted: Tue 11. Mar 2008, 15:50
by Kulinarisk
Sorry
phpmyadmin
But I just can't seem to make it work.
I enter phpmyadmin, tick acat_trash off and empty the trash, using the icon. When I try to name a new sub category in backend (Yes, I have used the same name before, since deleted) it highlights in red, and I can't use the same name.
Full disclosure: I am not very familiar with phpmyadmin