[SOLVED] Question about deleting lots of shortcuts

[pbrady]

Hi,

I have run into an interesting problem. I need to delete a ton of shortcuts (9 pages worth!) from my setup and the only way to do so within CMSms is from "My Preferences --> Manage Shortcuts" menu - one at a time.

How I got 9 pages of shortcuts is a separate issue from this question, but I'm investigating it and will report what i find here (may be an Acunetix injection test problem).

At any rate, I was wondering two things:

1. Can I delete the bookmarks themselves from the MySQL DB without adversely affecting my CMSms installation and;

2. If I can, should I optimize tables afterwords to clean up and what, if anything, should I do beyond that?

I see within the CMSms DB that the table containing all the bookmarks is called:

CMS_ADMIN_BOOKMARKS

but I also noticed there is a another table called:

CMS_ADMIN_BOOKMARKS_SEQ

that seems related.

I just want to make sure if I do this I won't hose my core installation. All I want to do is to delete the bogus bookmark entries from the CMS_ADMIN_BOOKMARKS table.

My system config (including my linux server info) are posted below:
----------------------------------------------

Cms Version: 1.4.1

Installed Modules:

   * CMSMailer: 1.73.14
   * FCKeditorX: 1.0.5
   * MenuManager: 1.5.1
   * ModuleManager: 1.2.1
   * News: 2.8.2
   * nuSOAP: 1.0.1
   * ThemeManager: 1.0.8
   * MysqlDump: 1.2.3
   * VisitorStats: 0.1.1
   * Uploads: 1.3.0
   * TinyMCEAdv: 2.2.2
   * FileManager: 0.4.1
   * Printing: 0.2.5
   * FrontEndUsers: 1.4.3
   * SelfRegistration: 1.2
   * CustomContent: 1.4.10
   * TinyMCE: 2.4.5
   * TemplateExternalizer: 1.0.4
   * Comments: 1.8.1
   * XStandard: 1.2
   * FCKeditorX: 1.0.3
   * CGExtensions: 1.3
   * Uploads: 1.3.0
   * CompanyDirectory: 1.1.1
   * Glossary: 0.6.2
   * FLVPlayer: 1.0.3


Config Information:

   * php_memory_limit:
   * process_whole_template: true
   * max_upload_size: 314572800
   * default_upload_permission: 664
   * assume_mod_rewrite: false
   * page_extension:
   * internal_pretty_urls: false
   * use_hierarchy: false


Php Information:

   * safe_mode: Off (False)
   * phpversion: 4.4.4-8+etch4
   * memory_limit: 64M
   * max_execution_time: 900
   * gd_version: 2
   * session_save_path: /var/lib/php4 (1733)


Server Information:

   * Server Api: apache2handler
   * Server Db Type: MySQL (mysql)
   * Server Db Version: 5.0.32
   
   * Linux pubs 2.6.18-5-686 #1 SMP Wed Oct 3 00:12:50 UTC 2007 i686 GNU/Linux (my server)
   * PHP 4.4.4-8 - debian etch



----------------------------------------------
Thanks in advance for any help you can provide.

-p

[Dr.CSS]

Do a back up of DB then remove the unwanted bookmarks, if it hoses the DB reimport...

[pbrady]

Hi Mark,

I was hoping to get a more specifics on whether, in general, this is a good practice for simple text deletes like this. 

I appreciate the feedback and will do a backup again prior to doing anything (always good advice). But I will not mark this as solved in hopes that someone might provide more specifics.

Best,

-p

[pbrady]

Hi,

Just wanted to update community on this. I was able to use the "empty" command from phpmyadmin to empty out the cms_admin_bookmarks table in the CMSms DB. I had not bookmarks in there I cared about and it deleted 9 pages of bookmarks that were erroneously put in there by Acunetic Web Scanner. (ouch!)

[Dr.CSS]

Good... the [solved] goes in the subject line of the first post...

[pbrady]

done.

Good... the [solved] goes in the subject line of the first post...