help with quick title

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   help with quick title
stealthusa
CZ Addict
stealthusa has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Self-Employed
Age: 58
Gender: Male
Fav. Sports Team: Cowboys
Website:
Status: Offline
Joined: Jan 23, 2004
0.05 posts per day
Posts: 353
Points: 14,459
 Yahoo Messenger  ICQ Number
hello i have been trying to get this quick title installed and can when i try to put the sql in i get this error on it

can't create table something phpbb in my sql db is nuke_bb but on this sql it is phpbb is that the problem how would i fix this



Back to top Reply with quote
#2   re: help with quick title
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
everywhere it says phpbb change that to nuke_bb




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   
stealthusa
CZ Addict
stealthusa has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Self-Employed
Age: 58
Gender: Male
Fav. Sports Team: Cowboys
Website:
Status: Offline
Joined: Jan 23, 2004
0.05 posts per day
Posts: 353
Points: 14,459
 Yahoo Messenger  ICQ Number
ok did that now i am getting this in the forums

Unable to query Quick Title Addon informations.

and then when i got to admin forums and click on the quick title i get this message

Couldn't obtain title data

DEBUG MODE

SQL Error : 1146 Table 'stealth_nuke.title_infos' doesn't exist

SELECT * FROM title_infos ORDER BY id ASC LIMIT 0, 40

Line : 280
File : /home/stealth/public_html/html/modules/Forums/admin/admin_quick_title.php




_________________
Back to top Reply with quote
#4   
stealthusa
CZ Addict
stealthusa has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Self-Employed
Age: 58
Gender: Male
Fav. Sports Team: Cowboys
Website:
Status: Offline
Joined: Jan 23, 2004
0.05 posts per day
Posts: 353
Points: 14,459
 Yahoo Messenger  ICQ Number
i think something is wrong with the sql i don't know but if you wish could give you user and pw if you want to get into the site




_________________
Back to top Reply with quote
#5   
stealthusa
CZ Addict
stealthusa has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Self-Employed
Age: 58
Gender: Male
Fav. Sports Team: Cowboys
Website:
Status: Offline
Joined: Jan 23, 2004
0.05 posts per day
Posts: 353
Points: 14,459
 Yahoo Messenger  ICQ Number
ok i got it fixed but when you are in the forums and use like fixed and click the buttom you get this url not found.




_________________
Back to top Reply with quote
#6   re: help with quick title
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
You would have to attach the hack its been a while since I seen it.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#7   
stealthusa
CZ Addict
stealthusa has been a member for over 20 year's 20 Year Member
usa.gif ohio.gif
Occupation: Self-Employed
Age: 58
Gender: Male
Fav. Sports Team: Cowboys
Website:
Status: Offline
Joined: Jan 23, 2004
0.05 posts per day
Posts: 353
Points: 14,459
 Yahoo Messenger  ICQ Number
o boy don't know even where to start LOL




_________________
Back to top Reply with quote
#8   re: help with quick title
Proxy
CZ Super Newbie
Proxy has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Nov 17, 2004
0.00 posts per day
Posts: 33
Points: 827
   
I know it's been a while since someone had this problem, but now I do lol.

I had the same problems as the guy above.



Couldn't obtain title data

DEBUG MODE

SQL Error : 1146 Table 'user.title_infos' doesn't exist

SELECT * FROM title_infos ORDER BY id ASC LIMIT 0, 40

Line : 280
File : /home/public_html/admin/admin_quick_title.php


But i just went into the admin_quick_title.php file and everywhere it said "TITLE_INFOS" I changed it to "phpbb_title_infos_table" because that's what the SQL inserted was... this...


ALTER TABLE phpbb_topics ADD title_compl_infos VARCHAR (255) ;

CREATE TABLE `phpbb_title_infos_table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`title_info` VARCHAR( 255 ) NOT NULL ,
`date_format` VARCHAR( 25 ) ,
`admin_auth` TINYINT( 1 ) DEFAULT '0',
`mod_auth` TINYINT( 1 ) DEFAULT '0',
`poster_auth` TINYINT( 1 ) DEFAULT '0',
UNIQUE (
`id`
)
);



Anyways basically I just made it all lowercase and added phpbb to the front and table to the back...

And wala the problem i was having in the acp was fixed..

But now I get the infamous "Unable to query Quick Title Addon informations." When I try to view a post. I have no idea what to do now. I manually figured out how to fix the other problems but this isn't specific on what the problem is.

Anyone else know how to fix it? Or the guy up there.. didnt say HOW he fixed it, just said he fixed it. I hate when people don't post back that they fixed a problem and how. Defeats the point of a help forum icon_neutral.gif

Thanks in advance.



Back to top Reply with quote
#9   re: help with quick title
Proxy
CZ Super Newbie
Proxy has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Nov 17, 2004
0.00 posts per day
Posts: 33
Points: 827
   
Ok for whoever else has/had this problem, you have to do this...



#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Begin Quick Title Edition Mod 1.0.0 by Xavier Olive.
define('TITLE_INFOS_TABLE', $table_prefix.'title_infos');
// End Quick Title Edition Mod 1.0.0 by Xavier Olive.



Now, like me, you should be having a problem with it actually doing anything. lol
When you go to the topics or forums you want and click "Moderate this Forum" it shows all the topics with check boxes and gives you the options to edit / delete / move / lock / unlock / and Title Edit...

But when you select a topic with the check box and hit "Title Edit" it just says


The titles of the selected topics have been edited.

Click Here to return to the Moderator Control Panel

Click Here to return to the forum


But nothing has changed or anything.

In the ACP you have a new admin option to add Quick Title things, which I did, but it doesnt seem to work. I guess maybe this mod doesnt do what i thought it did, or I just dont know how to utilize it properly icon_neutral.gif



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum