Major Problems (not just dynamics - but caused by dynamics?)

[neverstop]

Hi,

I bought dynamics and installed it no problem. Then i realized my link directory wasnt working. It was giving an error about functions already being declared by the vba dyna include file.


Fatal error: Cannot redeclare construct_orderby() (previously declared in /home/thiswebs/public_html/includes/vba_dyna_functions.php:171) in /home/thiswebs/public_html/includes/functions_vba_links.php on line 45


So i figured I would uninstall dynamics for the time being as I need the links directory operational. And there is where the problems started....

As soon as the uninstall was done and it showed me the "we're sorry you didnt like it" message I started receiving constant vb error emails. see screenshot:
Untitled-3.jpg

Here is the error:

Invalid SQL:

SELECT languageid,
phrasegroup_adv_dyna AS phrasegroup_adv_dyna,
phrasegroup_calendar AS phrasegroup_calendar,
phrasegroup_adv_portal AS phrasegroup_adv_portal,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_adv_dyna' in 'field list'

I could not access any pages, just straight db errors. I had to add that field in phpmyadmin, then I was able to get to the dynamics install page i think and tried reinstalling the phrases. Then I was receiving an error from cmps_include_top at one of the hook locations. That error has stopped, but now two of my modules have just vanished, both having to do with the links directory. I tried installing another instance of dyna, and then reinstalling it fresh. There are options in the admincp for dyna now but i get db error when clicking, and I cannot access it as a reg user.

[neverstop]

So I have managed to install another instance, and remove the first. SO that all seems honky dorry.

But I still get this error in my links directory:

Fatal error: Cannot redeclare construct_orderby() (previously declared in /home/thiswebs/public_html/includes/vba_dyna_functions.php:171) in /home/thiswebs/public_html/includes/functions_vba_links.php on line 45

I get that on both showlink and browsecategory which are pretty important! heh

And I dont see why my modules dont work... here is the code for them (theyre basically identical:

<?php
// ++=========================================================================++

// The order you would like to pull the links in. 
// Enter 1 for newest, 2 for most viewed, 3 for most comments, 4 for highest rated, 5 for random
$order = 1;

// Enter the number of links you would like to display here
$limit = 10;

// Maximum characters of the links name before the rest will be replaced with '...'
// Set this to 0 to disable it.
$maxnamechars = 0;

// No further editing necessary

switch($order)
{
	case 2:
		$orderby = 'views DESC';
		break;
	case 3:
		$orderby = 'posts DESC';
		break;
	case 4:
		$votequery = 'IF(votenum >= 0, votenum, 0) AS votenum, IF(votenum >= 0 AND votenum > 0, votetotal / votenum, 0) AS voteavg,';
		$orderby = 'voteavg DESC, votenum DESC';
		break;
	case 5:
		$orderby = 'rand() DESC';
		break;

	default:
		$orderby = 'dateline DESC';
}



$getlinks = $vbulletin->db->query(" 
  SELECT $votequery links.*, links_categories.description AS catdesc, cfields.*, links_categories.title
  FROM " . TABLE_PREFIX . "adv_links AS links 
  LEFT JOIN " . TABLE_PREFIX . "adv_links_categories AS links_categories ON (links.catid = links_categories.catid) 
  LEFT JOIN " . TABLE_PREFIX . "adv_links_cfields_entries AS cfields ON (links.linkid = cfields.lid) 
  WHERE links.catid = 9  AND links.valid = 1
  ORDER BY $orderby 
  LIMIT $limit 
");
require_once(DIR . '/includes/class_bbcode.php'); 
while ($link = $vbulletin->db->fetch_array($getlinks))  
{
	$link['catname'] = stripslashes($link['title']);
	$link['catdesc'] = stripslashes($link['catdesc']);
	$link['name'] = fetch_trimmed_title(stripslashes($link['name']), $maxnamechars);
	$link['username'] = stripslashes($link['username']);
	$link['date'] = vbdate($vbulletin->options['dateformat'], $link['dateline'], true);
	$link['time'] = vbdate($vbulletin->options['timeformat'], $link['dateline'], true); 
	$link['posts'] = number_format($link['posts']);
	$link['replies'] = number_format($link['replies']);
	$link[votenum] = number_format($link['votenum']);
	
	$link['truerating'] = $link['votenum'] ? vb_number_format($link['votetotal'] / $link['votenum'], 2) : 0; 
	$link['roundrating'] = round($link['truerating']);
$parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
$link['description'] = $parser->do_parse($link['description'], false, true, true, true, false, false);

	$getbgrow = exec_switch_bg();
	eval('$linkbits .= "' . fetch_template('adv_portal_slide') . '";');
}

eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_slideshow') . '";');

?>

I added 'link' to portal output variables but no luck.

They are just POOOF gone.

[neverstop]

Here is the line of code where I recieve errors if i remove the dyna functions file:

($hook = vBulletinHook::fetch_hook('vba_cmps_include_getpage')) ? eval($hook) : false;

removing that line of code has allowed my site to sort of work for now. I can browse cats in my links directory, and going to links works as weell. BBCode in a custom field doesnt work tho.

I hope I can get this all fixed asap. I wantt o uninstall dynamics completely but I cannot take a chance of what happneded last time!

I really need my cmps modules back!

Cheers,
Ian

[neverstop]

Getting closer... it seems the confl;ict with LD and dyna was from one of these plugins:

vBa Dynamics CMPS Module (globalize $vba_dyna class) vba_cmps_fetch_vba_module [Edit] [Delete]
vBa Dynamics CMPS Module (load $vba_dyna class) vba_cmps_include_getpage [Edit] [Delete]
vBa Dynamics CMPS Module (Special Templates)

DIsabling those plugins has seemed to have solved the already declared error.


Now... why has my module disappeared......

(PS sorry for the multiposts but I want to make sure I include everything)

[rknight111]

Why are you figuring this out and not the software developer. I just bought this and have the links as well and am concerned before I even finish my install. I started my install and have several errors so now I am deleting untill they let me know whats going on. Who knows how long that will be.

[neverstop]

Hi rknight,

If you look at the timestamps on my posts, you will see they are all within a two hour timeframe. I know the dev takes the weekends off every now and then...

I am like 90% certain the problem was caused by the CMPS module you can find in the dynamics addons forum. There might be a bug with the uninstall script as well but I will wait on someone who knows what theyre doing to confirm that.

[neverstop]

Another update...

I have reinstalled the cmps module that vanished, and i have managed to get it to reappear! So, basically everything is running smoothly as far as I can see.

[KW802]

neverstop, I'll have to let Brian go over this one. Likely since the vBa products share a lot of common back-end code there was some overlap but he'd be able to spot the problem a lot faster than I.

[Brian]

Do you have the CMPS integrated with your links directory, and a module from vBa Dynamics enabled on the page that's integrated? If so, you will need to remove that module from that CMPS page as there are functions from the two products that will clash (as you've seen ).

[neverstop]

Hi Brian,

I I wanted to follow up and ask if you had looked at the uninstall script. I wanted to uninstall the script so I could start form scratch and do a fresh install. There was a problem when reinstalling with duplicate table columns. They were in the language table (adv_dyna_phrasegroup IIRC), the product table, and the plugin table.

Cheers,
Ian

[Brian]

Can you link me to the thread where the issue was posted to refresh my memory a bit? As far as I'm aware there should not be any issues with uninstalling.

[neverstop]

Well its all in this thread so linking would be kinda redundant heh ^ ..... When I uninstalled the first time, I got all those db errors from the cmps module (afaik). And reinstalling didnt work because of duplicate tables. I didnt think much of it, because I got it working be installing a second instance...


But I went and uninstalled everything so I could start from scratch (i was running a second instance of dynamics, with the ifrst instance uninstalled if that makes sense). After uninstalling everything, when I went to reinstall, I kept getting db errors - cannot alter table blah blah, duplicate column in table blah etc. I had to manuallly remove the column in phpmyadmin from the language table (adv_dyna_phrasegroup) and then had to do the same in the product table and plugin table.

[Brian]

Ahhh, sorry about that. I must not have looked up far enough. You said there though that you had to add the column back to the language table because of that conflict with the module, so I would think that might be where part of the problem was coming from. I've just tried testing the uninstall and install scripts locally on a secondary and main instance, but did not have any problems at all.