Cannot Add Blocks

Lieutenant Joined: Jul 09, 2003 Posts: 293

This seems to affect any 'patched' version of php-nuke.

For some reason any attempt to ADD a block results in nothing happening.

Tested on 6.8 and 6.9 with all patches (including speed patches etc.)

My knowledge on this indicates that the problem is with the following query found on or near line 404 or admin/modules/blocks.php in the function blocksadd():

sql_query("insert into ".$prefix."_blocks values (NULL, '$bkey', '$title', '$content', '$url', '$bposition', '$weight', '$active', '$refresh', '$btime', '$blanguage', '$blockfile', '$view')", $dbi);

I see three (four?) problems with this instruction:

1. the BID is NULL - The database defines this as auto-incrementing and non-null.

2. $btime does not exist in the database instead it exists as $time.

3. (4.) There are two fields expire and action that do not get added in this query

I'm trying to review my archives to see what happened to change this, but I'm assuming it happened some time back.

TIA!

J.

Major Joined: Jan 15, 2003 Posts: 1269 Location: USA

I'm a little confused. Tested with all patches including speed patches what do you mean speed patch? What other patches have you applied?

Lieutenant Joined: Jul 09, 2003 Posts: 293

Speed patches applied, but I don't beleive these caused anything of this nature, but so everyone knows.

Review the new 'Speed Freaks' forum for details of the changes here at nukecops.

J.

Lieutenant Joined: Jul 09, 2003 Posts: 293

Nobody read this forum?

J.

Lieutenant Joined: Jul 09, 2003 Posts: 293

Ok, here the latest.

I cannot see any changes to the files, so I'm assuming the changes were due to a sql file that was executed.

I fixed the $time variable in the database to $btime, since blocksadd() is the only function using it I can see that causing problems.

BUT it did not solve the problem.

At this point my fingers are pointing at two culprits:

MS-Analysis

Coppermine

I will review both and post back again.

J.

Posted: Sat Feb 28, 2004 9:15 am

the insert statement syntax looks fine.

1.the first value is suppose to be null to let the database assign it a value since it's auto_increment.

2. $btime is a variable name and can be named whatever
the programmer decided, leave that alone.

3. (4.) that's your problem, your nuke_blocks table has those 2 extra columns
since you applied an addon that was based on 7.0
but your insert statement still thinks you're running 6.9 or less because you are.

Lieutenant Joined: Jul 09, 2003 Posts: 293

No I'm not actually I've modified 7.0 to not work with the added fields (they don't exist, and I've double checked my patches to make sure they are succinct. It looks like my problem is old, and due to the modules broken bug I've found in the 'BLOCKS' forum.

Now I need to clarify what the fix is. I see LOTS of user's with this problem, and no clear fix.

J.

Lieutenant Joined: Jul 09, 2003 Posts: 293

Also 6.8 and 6.9 don't have them either...but they are still broken as well.

J.

Lieutenant Joined: Jul 09, 2003 Posts: 293

Yup, it appears my problems stem from a problem with the admin/modules/module.php not blocks.php as I thought.

So I'm not going to review the sql files in the patches =)

Doesn't look like MS-Analysis or Coppermine had any affect to cause this.

J.