Support Forum

uhm, what module?

-----
Friends rock, bullshit walks

@infopro It's a coding question... I'll field this one.

@destruct It's fairly difficult to read code of the forums. What I would do as a debug is to put an echo $SQL after each SQL statement is formed. This will give you the SQL that is being executed. This will allow you to either spot an instant problem with the pntables array or your forming of the SQL. If you can't spot anything at this stage then you've got the SQL so paste this into phpMyAdmin and you may get some extra information here.

-Mark

-Mark

-Mark

-Mark

????

didnt know you were skitzophrenic mate

-----
Regards,
Simon

itbegins.co.uk - Zikula Consulting

Please read the Support Guide

Well I had tried that Mark but the problem was I wasn't getting an error, it was telling me it was initializing just fine although tables weren't appearing. I figured out problem was I missing the // on a line which should have been commented and that at least got me to the stage where I could view the SQL. I player around with the SQL and fgiured out that this line:

Code

PRIMARY key($rulescolumn[rid]))"; 

was causing me problems. I changed it to:

Code

PRIMARY key(rid))"; 

And it worked fine. What I do find confusing is that before making this change, the SQL statement was executing just fine in phpMyAdmin but it just wouldn't work on site. WOnder why that is.

HammerHead

-Mark

-Mark

????

didnt know you were skitzophrenic mate

Who me?

Who Him?

-Mark squared.....

Destruct

Well I had tried that Mark but the problem was I wasn't getting an error, it was telling me it was initializing just fine although tables weren't appearing. I figured out problem was I missing the // on a line which should have been commented and that at least got me to the stage where I could view the SQL. I player around with the SQL and fgiured out that this line:

Code

PRIMARY key($rulescolumn[rid]))"; 

was causing me problems. I changed it to:

Code

PRIMARY key(rid))"; 

And it worked fine. What I do find confusing is that before making this change, the SQL statement was executing just fine in phpMyAdmin but it just wouldn't work on site. WOnder why that is.

Reallly dificult to tell without having your code in front of me. The text wrapping on these forums really doesn't make this kind of diagnostic easy.

Feel free to shoot be a copy of the code to markwest at PostNuke dot com as i'll take a further look.

-Mark