SMF's SSI.php & Drupal.... What The...

[PHPD҉irector]

Well in one of my drupal blocks i have this php code;

Code Select Expand

<?php

require("/home/phpdirec/public_html/forum/SSI.php");

ssi_news();

?> 

I'm right in saying that should display my forums news yeah?

Well as soon as i save it i get an error page;

Code Select Expand

Fatal error: Cannot redeclare db_query() (previously declared in /home/phpdirec/public_html/includes/database.mysql-common.inc:33) in /home/phpdirec/public_html/forum/Sources/Subs.php on line 330

Warning: Table 'phpdirec_sitemain.smf_watchdog' doesn't exist query: INSERT INTO smf_watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:793:\"Table 'phpdirec_sitemain.smf_sessions' doesn't exist\nquery: UPDATE smf_sessions SET uid = 1, cache = 0, hostname = '92.23.81.77', session = 'messages|a:2:{s:6:\\"status\\";a:3:{i:0;s:39:\\"The block configuration has been saved.\\";i:1;s:39:\\"The block configuration has been saved.\\";i:2;s:39:\\"The block configuration has been saved.\\";}s:5:\\"error\\";a:1:{i:0;s:215:\\"warning: require(/forum/SSI.php) [<a href=\\'function.require\\'>function.requi in /home/phpdirec/public_html/includes/database.mysql.inc on line 128

What's going on? 

[PHPD҉irector]

BUMP

[MrPhil]

Any chance that you've ended up requiring SSI.php twice? Try changing require() to require_once() and see if anything improves.

[PHPD҉irector]

Same errror

[karlbenson]

does drupal have a function called db_query?

[PHPD҉irector]

Looks like it

[PHPD҉irector]

Anyone?

[MrPhil]

does drupal have a function called db_query?

Looks Like It

Well then, there you are. If both SMF and Drupal are trying to define a function "db_query", there's bound to be problems. I would suggest renaming the SMF version to "smf_db_query", and of course, all references to it. You might try first looking at both functions, and if they're exactly the same, you could just remove one of the definitions.

As SMF gets integrated with portals and CMSs on more and more sites, we're bound to see increasing numbers of such conflicts. It would be good for the SMF developers to start thinking about renaming all functions with an smf_ prefix to prevent such name conflicts.

[PHPD҉irector]

Sorry, i don't understand what you mean :S

[MrPhil]

Sorry, i don't understand what you mean :S

SMF defines a function named "db_query". Drupal evidently defines a function named "db_query". PHP doesn't like two separate definitions of something with the same name, even if the functions are identical. One of the names has to change.

[PHPD҉irector]

So how do i changes SMF's one? Will it be easy?

I hope it does not effect anything else if i change it

Thanks

[MrPhil]

Will it be easy? No. It would probably be best to download either SMF or Drupal (all the PHP files) to your PC. Scan through them and replace all instances of db_query with smf_db_query (or drupal_db_query, if you choose to modify Drupal instead). Re-upload all changed files and hope for the best. I would not try to do such an update in-place on your server, as it's too easy to make a mistake and change some of Drupal's db_query's or vice-versa. You'll have your hands full already, doing on your PC.

[PHPD҉irector]

Well, i'll do that when i have time but if there's another way i'd like to do that first.

Is it possible with php to scan my forum, find the news and return it. So like SSI but fsock, or curl or something?

[PHPD҉irector]

Well, i'll do that when i have time but if there's another way i'd like to do that first.

Is it possible with php to scan my forum, find the news and return it. So like SSI but fsock, or curl or something?

[greyknight17]

Is this issue resolved now? If not, have you tried the suggestion by MrPhil yet?

[qqq111]

I have the same problem. Is it possible to fix this?

[JBlaze]

Hello, just going through some old support topics. Do you still require assistance with this issue?

If so, please reply with more information about what isn't working.

Additionally, if this is already solved, please mark it solved by clicking 'Mark Topic Solved' at the lower left of your screen.