Advertisement:
GCWebhosting

Author Topic: Mods can't create tables in MYSQL database  (Read 24404 times)

Offline Dannii

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,212
  • Mind the volcano!
    • curiousdannii on GitHub
Re: Mods can't create tables in MYSQL database
« Reply #40 on: May 10, 2008, 11:28:35 PM »
Are you still having problems?
"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #41 on: May 11, 2008, 12:53:17 AM »
Are you still having problems?

Yep, but I am doing just fine with all mods that don't require MYSQL tables...
I install every single mod that gets released :)

Offline Dannii

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,212
  • Mind the volcano!
    • curiousdannii on GitHub
Re: Mods can't create tables in MYSQL database
« Reply #42 on: May 11, 2008, 12:57:05 AM »
Oh dear... you must have too many of them by now... maybe that's the problem? :P

Did you try turning on debugging?
"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #43 on: May 11, 2008, 12:58:52 AM »
Oh dear... you must have too many of them by now... maybe that's the problem? :P

Did you try turning on debugging?

That can't be the problem because I already had the problem from the start.

Where can I turn on debugging?

Offline Dannii

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,212
  • Mind the volcano!
    • curiousdannii on GitHub
Re: Mods can't create tables in MYSQL database
« Reply #44 on: May 11, 2008, 01:21:12 AM »
Try adding $db_show_debug = true; to Settings.php
"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #45 on: May 11, 2008, 05:30:16 PM »
Try adding $db_show_debug = true; to Settings.php

Danni, can I trust you with complete acces to my forum and the database? I am willing to give you 10$ ( I know it's not much ) for your time.
Only someone with good SFM knowledge will be able to find out what's rong.

Offline Dannii

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,212
  • Mind the volcano!
    • curiousdannii on GitHub
Re: Mods can't create tables in MYSQL database
« Reply #46 on: May 11, 2008, 08:22:17 PM »
I'll do it for free, but I don't have much time. I'll see if I can squeeze it in tonight. PM me the details. (change your passwords first if you like, and then change them back once I'm finished.)
"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #47 on: May 12, 2008, 06:44:49 AM »
I'll do it for free, but I don't have much time. I'll see if I can squeeze it in tonight. PM me the details. (change your passwords first if you like, and then change them back once I'm finished.)

I've sent you an email and a PM.

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #48 on: May 13, 2008, 05:07:41 PM »
Anyone else willing to help me. I've had problems with my forum for 17 days now. 3 people offered to help, none of them showed up yet.
I know I have no right to complain because it's not their job to help but 17 days is long, very long...

Look at it this way, the problem that I'm having is pretty unique, look at it as a challenge lol :D

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #49 on: May 13, 2008, 07:52:58 PM »
The problems are solved. The majority of the problems I was experiencing were due to "crappy" coding in a couple of modification files. Some modifications contain the rong code to create and alter tables and others don't have a proper uninstallation file.

Carl from www.realapplets.com worked for hours on my forum and managed to fix every single error and every problem.

He configured my forum so that I get an email every time a mod alters or creates a new table, this way I see if the SQL querry is correct.


Offline Dannii

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,212
  • Mind the volcano!
    • curiousdannii on GitHub
Re: Mods can't create tables in MYSQL database
« Reply #50 on: May 14, 2008, 10:46:50 AM »
Glad to hear it, sorry I couldn't help, been flat out with uni work until now. Deleting your PMs now.
"Never imagine yourself not to be otherwise than what it might appear to others that what you were or might have been was not otherwise than what you had been would have appeared to them to be otherwise."

Offline Jelle Mees

  • Jr. Member
  • **
  • Posts: 140
Re: Mods can't create tables in MYSQL database
« Reply #51 on: May 14, 2008, 11:53:36 AM »
Glad to hear it, sorry I couldn't help, been flat out with uni work until now. Deleting your PMs now.

Np, you DID help me. Thanks. ;)