Dragonfly CMS v9 ⇒ Modules & Blocks :: Archives ⇒ blogs problem :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexModules & Blocks

Archived ⇒ blogs problem


hi i downloaded blogs 2.0.2
and install it to my site.
so i click on install module it says its ready for use, but the blogmodule sodesent work, this error shows:

CMS Warning line 75: On /index.php?name=Blogs While executing query "SELECT id, aid, title, timestamp FROM cms_blogs WHERE private='0' OR aid='cakano' ORDER BY timestamp DESC LIMIT 10" the following error occured: Table 'cakanoteam_interspar.cms_blogs' doesn't exist In: C:\Inetpub\vhosts\cakano.net\httpdocs\modules\Blogs\index.php on line: 325

but when i go to my sql db there is not installed no blog sql tables Confused

howto fix this.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


You are missing a table. table name : cakanoteam_interspar.cms_blogs. try uninstalling it. Make sure you have the latest version an re upload the files. then install it again.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


Hey Diz check out your signature. The link is directed to dfaddons.com.com!

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


i tried uninstalling it, and only shows un error has acured the webmaster...

so any idea?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


if your loged in as admin when you se that error schroll down to bottom of page and you will see the debug error showing copy and paste that here please.




Thanks Catch ill fix asap

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


includes\db\db.php * CMS Warning line 75: On /admin.php?op=modules&uninstall=Blogs While executing query "DROP TABLE cms_blogs" the following error occured: Unknown table 'cms_blogs' In: C:\Inetpub\vhosts\cakano.net\httpdocs\includes\classes\installer.php on line: 69

here

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


Run this sql

/*Table structure for table `cms_blogs` */ DROP TABLE IF EXISTS `cms_blogs`; CREATE TABLE `cms_blogs` ( `id` int(11) NOT NULL auto_increment, `aid` varchar(30) NOT NULL default '', `title` varchar(80) default NULL, `text` text NOT NULL, `private` tinyint(1) NOT NULL default '0', `timestamp` int(10) unsigned NOT NULL default '1189128801', `views` int(10) NOT NULL default '0', `privcomm` tinyint(1) NOT NULL default '1', `topic_id` mediumint(8) unsigned NOT NULL default '0', `post_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `aid` (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Then check and see if the module is working.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Multiple Setups


I believe you should be running this query

/*Table structure for table `cakanoteam_interspar.cms_blogs` */ DROP TABLE IF EXISTS `cakanoteam_interspar.cms_blogs`; CREATE TABLE `cms_blogs` ( `id` int(11) NOT NULL auto_increment, `aid` varchar(30) NOT NULL default '', `title` varchar(80) default NULL, `text` text NOT NULL, `private` tinyint(1) NOT NULL default '0', `timestamp` int(10) unsigned NOT NULL default '1189128801', `views` int(10) NOT NULL default '0', `privcomm` tinyint(1) NOT NULL default '1', `topic_id` mediumint(8) unsigned NOT NULL default '0', `post_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `aid` (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/2.0.54 (Unix)/5.0.51/5.2.6/DragonflyCMS 9.2.1


ok, i added the sql db that you gave me, now here is a new problem, when i want to write something in to my blog this error shows:

CMS Warning line 75: On /index.php?name=Blogs While executing query "INSERT INTO cms_blogs VALUES (NULL, 'cakano', 'kaj maaaaaaaaaaaaa', 'weeeeeeeeeeeeeeex :opa:', '0', '1189693544')" the following error occured: Column count doesn't match value count at row 1 In: C:\Inetpub\vhosts\cakano.net\httpdocs\modules\Blogs\index.php on line: 41

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


both queries are wrong.

IgorMM at this point we need to do a full clean up.

1) Make sure you don't have any $_blogs table.
2) Make sure you don't have "Blogs" inside the $_modules table.
3) Clean up your site cache.
4) Fully re-upload a fresh version
5) Go to admin modules and install.

Let us know who it goes.

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.7 / PHP 7.3 / head


hi.

i did like you sad NanoCaiordo, and now finaly works like it must Big grin thxxx

now can you just tell me isit posible to put youtube videos link in to this blogs, so my users can watch videos from there blogs enteris Confused

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


Be aware of bandwidth issues doing this, but sure!

read as; you better have lots of bandwidth Smile

J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}


yes i know aboud traffic and all that.

but i asked is it possible to Link a video from youtube to my blogs? i didnt mean to put videos on my server and link them to blogs.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux , 2.0 , 5.0.51a , 5.2.6 , 9.1.2.1


My "aware"ness item stands Smile

Ignore if you wish.

J.
j e r u v y a t y a h o o d o t c o m

Need help? Look here: www.dragonflycms.org/W...d=112.html
Need to chat? Look for me on irc.freenode.net

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Ubuntu7.10/Debian3.1 - 2.2.3/1.3.37 - 5.0.38/4.0.27 - 5.2.1/4.4.7 - CVS/9.1.2}


Yes, there is a hack to add the BBcode for YouTube to the BBCode WYSIWYG form.

Among other places, that hack is here: www.ehpdesigns.com/Dow...id=61.html

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Unix / 2.0.46 (Red Hat) / 0.9.7a / 4.1.9-standard / 4.3.2 / 9.0.6.1

All times are UTC