The secure CMS.

Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 09:30 am EST

Geeklog Forums

I have killed my site

 New Topic  Post Reply
 05/22/04 04:53pm (Read 1,965 times)  
Status: offline

Sniper12

Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
I have install the birthday plugin and my site don't load, I have made a backup of the database but when I will load it comes whit this error

SQL-forespørgsel :

CREATE TABLE geeklog_faq_topics(

topicID int( 4 ) NOT NULL auto_increment,
catID int( 4 ) DEFAULT '0' NOT NULL ,
question varchar( 75 ) NOT NULL ,
answer text NOT NULL ,
keywords varchar( 125 ) NOT NULL ,
PRIMARY KEY ( topicID ) ,
UNIQUE topicID( topicID ) ,
KEY keywords( keywords ) ,
KEY answer( answer )
)

MySQL returnerede:


BLOB column 'answer' used in key specification without a key length
Tilbage


And this in the error log file
lør 22 maj 2004 22:31:39 CEST - 1146: Table 'sugecrew_dk.geeklog_faq_topics' doesn't exist. SQL in question: SELECT COUNT(*) FROM geeklog_faq_topics


Can somebody help me I am not good at mysql, I now That it says that it is the FQA topic it can't make but why.

The site is www.sugecrew.dk
 Quote
 05/22/04 05:11pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Try disabling the FAQ plugin. To do that, go to Geeklog's gl_plugins table and set the field 'pi_enabled' to 0 for that plugin (using phpMyAdmin or MySQL from the command line).

bye, Dirk
 Quote
 05/22/04 05:19pm  
Status: offline

Sniper12

Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
Thanks Dirk

Can I install the FAQ again ?
 Quote
 05/22/04 06:03pm  
Status: offline

Sniper12

Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
I have installed the FAQ again and it works fine, do the birthdays_1.0_1.3.7 plugin not work whit geeklog 1.3.9
Maybe that way my site crashed.
 Quote
 05/22/04 06:44pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
I don't know anything about the Birthday plugin (other than that it's an old plugin, I think). But unless it has a serious bug, it shouldn't affect other plugins - or even delete their tables, which it appears to have done in your case?!

bye, Dirk
 Quote
 05/23/04 10:33am  
Status: offline

Sniper12

Forum User
Regular Poster
Registered: 11/25/03
Posts: 81
Location:Denmark
I have deleted it, thanks Dirk
 Quote
 05/23/04 05:50pm  
Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
answer text NOT NULL ,


Notice that no field length is set, so its fails to exicute the sql command.

Table 'sugecrew_dk.geeklog_faq_topics' doesn't exist. SQL in question: SELECT COUNT(*) FROM geeklog_faq_topics


Because the table sql command failed it must have failed the whole command. It can happen where when you upload a file to a ftp server sections of the file corrupt ie don't save so there is missing code. That maybe why it worked the 2nd time, or php may have glitched and lost that section of code when reading the file.
 Quote
 New Topic  Post Reply
All times are EST. The time is now 09:30 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content