DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • December 11, 2017, 05:31:06 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1] 2   Go Down
  Print  
Author Topic: Serious Call Stack Issues With Forums  (Read 1344 times)
0 Members and 1 Guest are viewing this topic.
TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« on: October 23, 2017, 01:50:33 PM »

Lonny's Forum thing and Mighty E's blogs both cause a call stack on my system.

Can't even uninstall them now but at least they are inactive.

What the heaven is the problem with these things and is there an actual module for a Player Forum somewhere??  One that actually works??
Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #1 on: October 23, 2017, 09:05:36 PM »

Screenshots of the errors?
Logged

TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #2 on: October 23, 2017, 11:15:59 PM »

Screenshots of the errors?

hummm, not sure I can post screenshots but I could reproduce the call stacks.

this is lonny's module call stack:

CREATE TABLE logdforum (`id` int(11) NOT NULL auto_increment,`postdate` datetime NOT NULL default '0000-00-00 00:00:00',`newpostdate` datetime NOT NULL default '0000-00-00 00:00:00',`author` text NOT NULL,`parent` int(11) NOT NULL default '0',`replies` int(11) NOT NULL default '0',`userid` int(11) NOT NULL default '0',`title` varchar(100) NOT NULL default '',`category` int(11) NOT NULL default '0',`content` text NOT NULL,PRIMARY KEY  (`id`)) TYPE=MyISAM;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
Call Stack:
1: db_query("CREATE TABLE logdforum (`...") called from /home/savmor/public_html/modules/forum.php on line 56
2: forum_install() called from /home/savmor/public_html/lib/modules.php on line 111
3: injectmodule("forum", true) called from /home/savmor/public_html/modules.php on line 70




here is Mighty E's blog call stack...
CREATE TABLE mod_mightyblogs (
blogid int(11) unsigned NOT NULL auto_increment,
author int(11) unsigned NOT NULL default '1' ,
date datetime NOT NULL ,
subject varchar(255) NOT NULL ,
body text NOT NULL ,
hits int(11) unsigned NOT NULL default '0' ,
PRIMARY KEY (blogid),
KEY date (date),
KEY author (author)) Type=INNODB
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type=INNODB' at line 10
Call Stack:
1: db_query("CREATE TABLE mod_mightybl...") called from /home/savmor/public_html/lib/tabledescriptor.php on line 24
2: synctable("mod_mightyblogs", Array(
"blogid"=>Array(
"name"=>"blogid", "type"=>"int(11) unsigned", "extra"=>"auto_increment"
), "author"=>Array(
"name"=>"author", "type"=>"int(11) unsigned", "default"=>"1"
), "date"=>Array(
"name"=>"date", "type"=>"datetime"
), "subject"=>Array(
"name"=>"subject", "type"=>"varchar(255)"
), "body"=>Array(
"name"=>"body", "type"=>"text"
), "hits"=>Array(
"name"=>"hits", "type"=>"int(11) unsigned", "default"=>"0"
), "key-PRIMARY"=>Array(
"name"=>"PRIMARY", "type"=>"primary key", "unique"=>"1", "columns"=>"blogid"
), "index-date"=>Array(
"name"=>"date", "type"=>"index", "columns"=>"date"
), "index-author"=>Array(
"name"=>"author", "type"=>"index", "columns"=>"author"
)
), true) called from /home/savmor/public_html/modules/mightyblogs.php on line 49
3: mightyblogs_install() called from /home/savmor/public_html/lib/modules.php on line 1327
4: install_module("mightyblogs") called from /home/savmor/public_html/modules.php on line 42
Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #3 on: October 24, 2017, 02:05:40 AM »

I'm noticing these in your call stacks:

TYPE=MyISAM;
Type=INNODB

Read this and you'll find the fix.

What the heaven is the problem with these things and is there an actual module for a Player Forum somewhere??  One that actually works??

So, yep, there is. It's just that old versions of modules require updates to work.
Logged

TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #4 on: October 24, 2017, 07:15:08 AM »

See that is why I post here.  Too get a nice answer like that.  Thanks, will follow this and report back.

Nope.  It did not help.

DROP TABLE logdforum
Unknown table 'logdforum'
Call Stack:
1: db_query("DROP TABLE logdforum") called from /home/savmor/public_html/modules/forum.php on line 74
2: forum_uninstall() called from /home/savmor/public_html/lib/modules.php on line 1262
3: uninstall_module("forum") called from /home/savmor/public_html/modules.php on line 50
« Last Edit: October 24, 2017, 07:22:10 AM by TGTarheel » Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #5 on: October 24, 2017, 01:18:08 PM »

Unknown table 'logdforum'

The explanation is in the error. The fix I gave you is only for the queries to install the module and database table - this query is to uninstall the module and database table, but in this case, the database table does not exist.
Logged

TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #6 on: October 24, 2017, 05:44:59 PM »

The problem is I can't uninstall it now in order to get the call stack that I got when I tried to install it.
Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #7 on: October 24, 2017, 08:54:02 PM »

Why do you need to recreate the callstack? Just fix the error with the thread I gave you, and click the reinstall link. Should be all fixed and installed properly.
Logged

TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #8 on: October 25, 2017, 06:44:27 AM »

Why do you need to recreate the callstack? Just fix the error with the thread I gave you, and click the reinstall link. Should be all fixed and installed properly.

I tried it.  It did not work.

That is why.  See above, I pointed out that it did not work.
Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #9 on: October 25, 2017, 09:49:20 AM »

I'm confused. You're saying you're trying to uninstall it, or are you reinstalling it like I said, which you said you tried?

The database table wasn't created, so the uninstall function can't drop the table. Just comment out the problematic code and uninstall the module.
Logged

TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #10 on: October 25, 2017, 01:02:18 PM »

I'm confused. You're saying you're trying to uninstall it, or are you reinstalling it like I said, which you said you tried?

The database table wasn't created, so the uninstall function can't drop the table. Just comment out the problematic code and uninstall the module.

I tried.  It does not work.

I followed your link and made the change in the code...it stiil would not install...or uninstall. or reinstall.

It is stuck in installed modules and won't drop back to uninstalled modules.

And it won't install, either.  i get the call stack.
Logged
Aeolus
Mod God
*****
Offline Offline

Posts: 1794


You're welcome.


View Profile WWW
« Reply #11 on: October 25, 2017, 06:38:45 PM »

I tried.  It does not work.

I followed your link and made the change in the code...it stiil would not install...or uninstall. or reinstall.

It is stuck in installed modules and won't drop back to uninstalled modules.

And it won't install, either.  i get the call stack.


But I just told you how to uninstall it in my last post?

The database table wasn't created, so the uninstall function can't drop the table. Just comment out the problematic code and uninstall the module.
Logged

Maverick
Captain of the Guard
***
Offline Offline

Posts: 122


View Profile
« Reply #12 on: October 25, 2017, 09:52:55 PM »

I tried.  It does not work.

I followed your link and made the change in the code...it stiil would not install...or uninstall. or reinstall.

It is stuck in installed modules and won't drop back to uninstalled modules.

And it won't install, either.  i get the call stack.


But I just told you how to uninstall it in my last post?

The database table wasn't created, so the uninstall function can't drop the table. Just comment out the problematic code and uninstall the module.

In the _uninstall function, comment out all of the "DROP table" code. Then uninstall.

The reason that it is not working for you now, is because in the function _uninstall code, you are asking to drop a table that does not exist (your initial error).
With the edit that was provided to you here:

I'm noticing these in your call stacks:

TYPE=MyISAM;
Type=INNODB

Read this and you'll find the fix.

You should be able to successfully install the module and create the table 'lodgforum' without any call stacks.

I hope this helps.   Smiley
« Last Edit: October 25, 2017, 09:56:34 PM by Maverick » Logged
TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #13 on: October 27, 2017, 11:55:27 AM »

I can try these things and get back to you all if this works.  

First I have to get it uninstalled...then do the fix again...and then try to re-install.

That fix won't screw up any existing tables, will it?

UPDATE:  I got it to uninstall now.  I had to also comment out almost the entire install function.

Now I have un-commented everything I had commented out.

Now I am trying the fix that I was linked to that had not worked the first time...

Now I re-applied the fix that was linked to....

And I still get the call stack


CREATE TABLE logdforum (`id` int(11) NOT NULL auto_increment,`postdate` datetime NOT NULL default '0000-00-00 00:00:00',`newpostdate` datetime NOT NULL default '0000-00-00 00:00:00',`author` text NOT NULL,`parent` int(11) NOT NULL default '0',`replies` int(11) NOT NULL default '0',`userid` int(11) NOT NULL default '0',`title` varchar(100) NOT NULL default '',`category` int(11) NOT NULL default '0',`content` text NOT NULL,PRIMARY KEY  (`id`)) TYPE=MyISAM;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 1
Call Stack:
1: db_query("CREATE TABLE logdforum (`...") called from /home/savmor/public_html/modules/forum.php on line 56
2: forum_install() called from /home/savmor/public_html/lib/modules.php on line 1327
3: install_module("forum") called from /home/savmor/public_html/modules.php on line 42
« Last Edit: October 27, 2017, 12:06:09 PM by TGTarheel » Logged
TGTarheel
Captain of the Guard
***
Offline Offline

Posts: 179


View Profile
« Reply #14 on: October 27, 2017, 12:11:53 PM »

Now I am back where I was.  i got it uninstalled.

i have my tabledescriptor.php back to what it was before the linked fix...which did not work.

I have the install and uinstall functions un-commented once again...as the original file is.

So now what?

I can't get the damn thing to install.

I guess I need my hand held here because I can't solve the call stack no matter what the heck I do.

So, for right now...

tabledescriptor.php....i s back to the original
forum.php is back to the original.

I have the file uninstalled.

When I try the fix to tabledescriptor...the install still gives the call stack noted in the previous reply.

And I have to go thru a huge production to get it uinstalled again.

So now I need to know where to go from here.

ARRRGH....

Admittedly this call stack appears a little sifferent from the first call stack I got that started this whole thread...i think...

Yes, the line numbers referenced in the last two lines of the call stack I get now...are different from what i first got.

but other than that...still a problem.

It would seem it does not like

$sql .= ") TYPE=MyISAM;";

But I doo not know what to do with this line.
« Last Edit: October 27, 2017, 12:19:19 PM by TGTarheel » Logged
Pages: [1] 2   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Please take the time to read the FAQ and browse the DragonPedia

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
20 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search