Error in sql when trying to split topics.

Posted: Sun Apr 29, 2007 3:10 pm

I have an error but not sure whats wrong.
The error is

[code]Could not delete edits

DEBUG MODE

SQL Error : 1064 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 ')' at line 1

** nukeedits WHERE edit_topic IN ()

Line : 922
File : D:\inetpub\vhosts\ladderdueling.com\httpdocs\modules\Forums\modcp.php[/code]

Posted: Sun Apr 29, 2007 3:13 pm

the ** says *Del from* (cant put full wording) but when I put that there this site (nukecops) gives me an error like cant access modules.php directly for some reason so i posted it here

and it does the same when i try to post the same code lines from my modcp.php so i uploaded in text format here

http://www.ladderdueling.com/modcp.txt

Posted: Mon Apr 30, 2007 5:10 am

wtwolf6 wrote:

the ** says *Del from* (cant put full wording) but when I put that there this site (nukecops) gives me an error like cant access modules.php directly for some reason so i posted it here

and it does the same when i try to post the same code lines from my modcp.php so i uploaded in text format here

http://www.ladderdueling.com/modcp.txt

What version of bbtonuke are you using? If you are using anything from 2.0.19 or prior, upgrade your forums and problem solved Smile

It appears as you are using Nuke Platinum ? If so , the best thing you could do is go over to http://www.futurenuke.com and download their latest package . Then run the updates sequentialy.

Posted: Mon Apr 30, 2007 5:11 pm

using phpbb 2.0.11, not techno savy on words so im not sure what bbtonuke is so. I searched that site and only upgrade i found was from 2.0.20 to 2.0.21,

Honestly I stayed away from upgrades since this forums is heavily modded.
Isnt there a easier way, I know something is just causing problems but not sure what,

I have an admin who was taking care of this and installed a crap load of mods for it. Most work properly up to redirect pages but it redirects to phpbb urls and not nuke urls.

But that doesnt bother me, I looked at the database and the edits data base is nukeedits not nuke_edits also I believe the edits mod keeps records of edits and should post something like.

post edited by so and so but none of the topic edited show this either maybe its the database tables name?

Could I justr try renaming it to nuke_edits and that works?

<<<edit Tried it, Nope same error>>

Site Admin Joined: Aug 17, 2003 Posts: 12383

BBToNuke is the ported version of the phpBB files to work inside phpNuke. They are versioned the same as their phpBB versions, however... they are not cumulative. You will need to download and install them sequentially.

You can get all the BBToNuke packages from http://www.nukeresources.com

Posted: Mon Apr 30, 2007 5:50 pm

Off to install 11 packs should be a bit ill update when done.
Wait will these be ok for us on platinum wish I could go back but there is to much time invested in platinum.

Posted: Tue May 01, 2007 5:25 am

wtwolf6 wrote:

Wait will these be ok for us on platinum wish I could go back but there is to much time invested in platinum.

Yes, they are fine . The reason I suggested going to futurenuke is because I thought that their updates might take in consideration the fact that your boards come pre-modified with things such as the attachment mod etc ..

Posted: Tue May 01, 2007 4:30 pm

okidokie thanks,

I let yah know how it turns out

Posted: Mon May 14, 2007 10:05 pm

Ok i got to 2.0.14

when i realized when a user updates there profile it disables there account logs them out and i have to enable there account through the forum admin panel.

Any ideas how to solve this?

Posted: Tue May 15, 2007 2:07 am

wtwolf6 wrote:

Ok i got to 2.0.14

when i realized when a user updates there profile it disables there account logs them out and i have to enable there account through the forum admin panel.

Any ideas how to solve this?

Just keep updating until you are current . These updates address bug fixes and security flaws and more .

Posted: Tue May 15, 2007 7:00 pm

i tried the 15 patch but after,
all pages in the forums where broke from bbcode.php,
parse error illegal t string line 1111

I cant go further with the patches so I need some ideas on what causes the profile disabling.

Posted: Wed May 16, 2007 4:51 am

wtwolf6 wrote:

i tried the 15 patch but after,
all pages in the forums where broke from bbcode.php,
parse error illegal t string line 1111

I cant go further with the patches so I need some ideas on what causes the profile disabling.

Make sure you have the correct updates and update until you are current .