PDA

View Full Version : How to remove empty module name ?


StewardManscat
07-20-2004, 05:09 PM
The power of this system is only just becoming evident to me. I like it more every day. Nice work.

I messed up: somehow adding a module with no name. So under "Edit Modules" I can move it from column to column, but cannot select it to put the title in or delete it.

I suppose I can remove a table row with a query, but I am a little nervous about doing that without knowing what might be orphaned in the database.... ?

Please and thank you.

Fargo
07-20-2004, 05:12 PM
Ive done this one before as well. Removing the row didnt seem to have any adverse effects. I suggest backing up your DB, then go for it!

Our Sponsors
 

Realist
07-20-2004, 06:03 PM
I have one as well.

Anyone?

Polo
07-20-2004, 06:08 PM
The way i did it, is i went to phpmyadmin and delted the module manually... i think brian will incorporate something in the future to delete modules.. but i dont know, would be useful for many... but i really dont know

Our Sponsors
 

StewardManscat
07-21-2004, 08:49 PM
The table name is: vb_adv_modules.
The query is: DELETE from vb_adv_modules WHERE title=''

If you never hear from me again (in this thread, dreamer), it worked.

Thanks to all who replied.

Polo
07-22-2004, 09:09 AM
yeah but i dont think you add the " in the query, it will give you a syntax error

StewardManscat
07-23-2004, 10:46 AM
No errors mate. Those are two single quotes, not a double quote. It means WHERE title is empty.

Polo
07-23-2004, 12:12 PM
oh ok, good you point that out, it will be useful as reference.. ;)