Page 1 of 1

PLS HELP ! The requested topic does not exist.

Posted: Sun Nov 21, 2010 10:10 am
by sam_8085
Hello, I have done lot of modifications to my board. I have checked the functionality of the mods but I forgot to check posts functionality. I dont want to blame any mods cos its truely my mistake.

Now I'm getting a message The requested topic does not exist.

Image

I'm getting this for few topics its irrelevant of date, user, forum. I dont know why it is happening. I had backup of database (today before backup) I restored that. After restoring I'm getting SQL error if i open those posts.

So Do i have a chance to get my posts back ?

Guys please help me with this ! I'm so panic now

Re: The requested topic does not exist.

Posted: Sun Nov 21, 2010 10:17 am
by sam_8085
These are the few list of SQL (Which I remember) I have run through phpMYADMIN

breizh_ajax_checks_1_0_0

Code: Select all

DELETE FROM phpbb_config WHERE config_name = 'breizh_ajax_checks_version';
INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('breizh_ajax_checks_version', '1.0.0', '0');


Welcome PM on first Login (WPM)

Code: Select all

	CREATE TABLE phpbb_wpm (
	wpm_config_id int(3) NOT NULL,
	wpm_enable tinyint(1) unsigned NOT NULL,
	wpm_send_id mediumint(8) NOT NULL,
	wpm_preview tinyint(1) unsigned NOT NULL,
	wpm_variables varchar(255) NOT NULL,
	wpm_subject varchar(100) NOT NULL,
	wpm_message mediumtext NOT NULL,
	wpm_version varchar(255) NOT NULL,
	PRIMARY KEY	(wpm_config_id)
	) ;

	INSERT INTO phpbb_wpm (wpm_config_id, wpm_enable, wpm_send_id, wpm_preview, wpm_variables, wpm_subject, wpm_message, wpm_version) VALUES(1, 1, 2, 0, '', 'Welcome to {SITE_NAME}!', 'Hello, [b]{USERNAME}[/b]!\n\nWelcome to {SITE_NAME}	({SITE_DESC})\n\nYou registered on [b]{USER_REGDATE}[/b]. According to your input, your email is [b]{USER_EMAIL}[/b] and you live in timezone [b]{USER_TZ}[/b]. It is nice to know that you speak {USER_LANG_LOCAL}.\n\nYou can contact us here: {BOARD_CONTACT} or here: {BOARD_EMAIL}, whichever you prefer, at anytime. Thank you for choosing us.\n\n-Thank you for registering at {SITE_NAME}!\n\nThanks, {SENDER}', '2.2.5');
Custom BBCode only MOD

Code: Select all

ALTER TABLE phpbb_bbcodes ADD display_only_for_mod tinyint(1) UNSIGNED DEFAULT '0' NOT NULL;

Re: PLS HELP ! The requested topic does not exist.

Posted: Sun Nov 21, 2010 10:31 am
by sam_8085
Support Request Template
What version of phpBB are you using? phpBB 3.0.7
What is your board's URL? http://www.bay32.org/
Who do you host your board with? Ibeehosting
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? Yes
What MODs do you have installed? AutoMODS
Anti Double Posts
Ban users by x warnings
Force Login
Login After Register
Prevent Topic View Increase by Author
Prime Censor Block
Prime Login via E-Mail
Simple Trash Bin
Welcome Newest Member
Anti All Uppercase Letters
Multi Smile
Add Disclaimer

Manuall MODS
PM Notify & Guest Register bar
Live Preview
Live Preview for Quick Reply
PM Box Progress Bars
Full Quick Reply Editor
ReIMG Image Resizer
Prime Login via E-Mail
Show Banned Status
mChat
Javascript Logout Confirmation
Profile Views List
Please Wait
Extra topic field
Custom BBCodes in a select box
Login/Logout Smiley
IE6 No More
ACP Announcement Centre
TinyPic Plugin
Breizh Ajax Checks
Welcome PM at first login
Advertise Management
Groups Page
What styles do you currently have installed? absolution
What language(s) is your board currently using? English
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? Jumper
What password can be used to view this issue? welcome
When did your problem begin? I'm getting the following message for posts

The requested topic does not exist
Please describe your problem. I'm getting the following message for posts

The requested topic does not exist
Generated by SRT Generator ($Rev: 4502 $)

Re: PLS HELP ! The requested topic does not exist.

Posted: Sun Nov 21, 2010 11:12 am
by noth
save your forum via phpMYadmin

go back to a save you did 1 week ago, load that phpMYadmin into your forum

recheck ;)

Re: PLS HELP ! The requested topic does not exist.

Posted: Sun Nov 21, 2010 12:05 pm
by sam_8085
I did it, if I do so its giving SQL errors when I click those posts

Just now I have noticed one more thing, when I click on view your topics, its just showing up very few which are not included in to this error.

Waiting for some support team to help me out with this....

Re: PLS HELP ! The requested topic does not exist.

Posted: Mon Nov 22, 2010 7:57 am
by Oyabun1
If you're waiting for the support team you should post in the 3.0.x Support Forum and not the MOD Requests forum, they're much more likely to see your post there.

Re: PLS HELP ! The requested topic does not exist.

Posted: Tue Nov 23, 2010 8:08 am
by jsoni
I am not much experienced but you can try one option that drop all your database and create again by using phpmyadmin and also remove all phpbb files and upload again by using your backup.

I usally do this when I get big trouble. Because ually your backup of database and phpbb files must have data till last backup and it should work.

But if it doesnt work please don't blame me. Its on your own risk as I am not much experienced person like you all people. :)