Announcement

Collapse
No announcement yet.

Selecting a table that is not there after renumber

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Selecting a table that is not there after renumber

    Been working with styles, had played and eventualy had templets numbeter into the 1000's, templet number 14 is my top one now.

    Was at temp #12 and had another to inport i wished to play with, so under maintance I "rebuild the styles' checked the "Renumber all templates from 1" option - the slq data base i am on was told has ALTER, CREATE and DROP privileges' - am no guru so asked.

    Uploaded the new style with no problem -#13- tyed it and had the slq error -
    mysql error: Table '*****_*****.style' doesn't exist
    mysql error number: 1146
    -
    Ok checked - yes, database is *****_***** but the table is vb3_.style.

    ( i think i am translating this right ??? )

    Ok, deleted the style, ran "Repair / Optimize Tables" then re uploaded everything again. same error.

    HTML Code:
    Database error in vBulletin 3.0.0 Beta 5:
    Invalid SQL: SELECT styleid, title FROM style WHERE styleid IS NOT NULL AND userselect=1 GROUP BY styleid
    mysql error: Table '*****_*****.style' doesn't exist
    mysql error number: 1146
    Date: Tuesday 26th of August 2003 04:20:21 PM
    Script: [url="http://sdcbb.com/forum/index.php?s=&styleid=14"]http://sdcbb.com/forum/index.php?s=&styleid=14[/url]
    Referer: [url="http://sdcbb.com/forum/admincp/template.php?do=modify"]http://sdcbb.com/forum/admincp/template.php?do=modify[/url]
    Username: Ken j
    IP Address: **.***.***.***
    the other 2 styles work correctly, so everything must be right. since the renumber the upload is looking some place else. the config file is unchanged.

    the templets were put into the vb3_template and the name into the vb3_ style database.

    what went wrong?? or what needs to be done to correct this??
    or is it broke??

    tnks.
    .. . / GFXstyles certain amount of common sense is necessary to survive in this world !
    insanity leaves you no restrictions
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X