Photopost Variables creates errors in vB

[Fortissimo]

We just upgraded from 8.12 to 8.23. We have a program installed (DownloadsII) in the forum that worked with 8.12. With the upgrade to 8.23 and the new port of Photopost to vBulletin, we are getting a database error when we try to edit anything in Downloads.

I went through each part of the Photopost plugin, since that was the only variable that had changed recently. After turning them all off one by one and then turning them on, I narrowed it down to the Photopost Variables being the issue that was conflicting with Downloads.

The error is as follows:

Database error in vBulletin 4.2.0:

Invalid SQL:

UPDATE vb_dl2_files SET
`title` = 'March 13 in 13 Inspiration',
`description` = 'The attached is a PDF document with 13 things to inspire you on the 13th. You can read more about this challenge here:\nhttp://myurl/forum/forumdisplay.php?...-in-13-Project\n\nThis list contains suggestions and are not mandatory! If something else inspires you we would love to hear and see it in the challenge forum and gallery!',
`author` = 'My Name',
`_author` = '<a href=\"member.php?u=19504\">My Name</a>',
`url` = 'http://',
`extension` = '',
`category` = 8,
`size` = 0,
`pin` = 0,
`modqueue` = 0,
`link` = Resource id #20,
`lastedit` = 1363183147,
`lasteditor` = 'My Name',
`lasteditorid` = 19504
WHERE id = 1110;

MySQL Error : 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 'id #20,
`lastedit` = 1363183147,
`lasteditor` = 'My Name',
' at line 12
Error Number : 1064
Request Date : Wednesday, March 13th 2013 @ 08:59:07 AM
Error Date : Wednesday, March 13th 2013 @ 08:59:07 AM
Script : http://myurl/forum/downloads.php?do=edit&id=1110
Referrer : http://myurl/forum/downloads.php?do=edit&id=1110
IP Address : xxxxxxxx
Username : My Name
Classname : vB_Database
MySQL Version : 5.1.68-cll

If I turn of Photopost Variables, the database error goes away. If I turn it back on, the DB error shows up.

1. Can we fix this?
2. Can we turn of Photopost Variables until it can be fixed?

Thank you.

[Chuck S]

The proper thing would be to contact your hack author and correct his hack. You need to diagnose from that end.

We integrate with vBulletin we do not claim intergration with hacks or mods you may download and install from vbulletin.org

Your error is in whatever this part of the guys hack query is as a reference

Content visible to verified customers only.

There are no errors with your vbulletin photopost integration and install this issue is with the hack which has the error.

Your hack author probally needs to define his mysql resource and then restructure his query.

Obviously I do not use that hack so I can only point out where the issue is in his query.

Just for your reference except for a couple style class additions the 8.12 and 8.23 xml plugins are exactly the same. There are no changes that I can see.

My only guess would be maybe try placing this at the end of your photopost variables plugin

Content visible to verified customers only.

[Fortissimo]

I do plan on contacting them as well, however, since the issue happened only after upgrading from 8.12 to 8.23, the proper thing would be to contact you as well.

I will try your fix and see if that helps to alleviate the issue and see if the coder of the other software has any insight as well.

[Chuck S]

Well like the said I just gave you a suggestion to try. There is nothing wrong with your PhotoPost or your vbulletin. Your issue is with a hack. Neither bulletin or our company support hacks so we do not provide support for such issues with other peoples code.

Your issue is with there code. I understand the issue is with a conflict that program has with our plugins. I am merely saying our program guarantees to work with your forum. It is not our responsibility to make sure that hack works right with our app.

[Fortissimo]

Originally Posted by Chuck S

Content visible to verified customers only.

No need to respond to this information. Placing the above code crashes vBulletin.

Warning: mysql_close(): supplied resource is not a valid MySQL-Link resource in [path]/global.php(29) : eval()'d code on line 94

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:5615) in [path]/includes/functions.php on line 4513

---
Can Photopost Variables be turned off until we can get this resolved elsewhere? What does it run?

[Chuck S]

Like I said you need to get a fix from that hack/mod programmer. Our application and vbulletin are working fine together which is what we support. Either company ours or vbulletin do not support code hacks or problems they may cause.

Are your photopost and vbulletin tables in the same database?

[Fortissimo]

Originally Posted by Chuck S

Like I said you need to get a fix from that hack/mod programmer. Our application and vbulletin are working fine together which is what we support. Either company ours or vbulletin do not support code hacks or problems they may cause.

Are your photopost and vbulletin tables in the same database?

As I mentioned, I was not expecting or wanting a reply to the results of the possible fix you provided. I posted simply to let you know.

I do need an answer to this question.

Can Photopost Variables be turned off until we can get this resolved elsewhere? What does it run?

[Chuck S]

The photopost variables control the plugin content on the forum. You turn the photopost plugin off and then nothing shows on the forum.

No need to let us know anything about your downloads hack.

[Fortissimo]

Thank you. Since it's not possible to turn off just Photopost Variables by itself without it causing a critical error

Warning: require(/config-int.php) [function.require]: failed to open stream: No such file or directory in [path]/forum.php(787) : eval()'d code on line 48

Fatal error: require() [function.require]: Failed opening required '/config-int.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxx/public_html/forum/forum.php(787) : eval()'d code on line 48

until this is fixed, I will turn off the entire plugin.

[Chuck S]

yes to run the plugins you must have the variables.

[Fortissimo]

Well that isn't going to work. You have to have the plugin active in order for the navigation system to show up... and since the navigation is no where else, it has to be on.

Again, there is no need for a reply. I am posting for the benefit of anyone else who ends up with the same issue. I do not expect any technical support from Photopost for this issue.

[Chuck S]

Then I will close this thread as there is no support issue.