MySQL Field Type Plugin

12 years 1 month ago #190624 by 3cellhosting
Replied by 3cellhosting on topic Re: MySQL Field Type Plugin
It will still work. The site I am using it on has been developed in both 1.5 and then 1.7 - change is down to client who has goalposts on roller-skates!

David
www.3cellhosting.com - where personality, creativity and integrity come as standard.
The following user(s) said Thank You: akasharkbow

Please Log in to join the conversation.

12 years 1 month ago - 12 years 1 month ago #190639 by datamat
Replied by datamat on topic Re: MySQL Field Type Plugin
hi,

how can i map to the kunena total thanks?

im using: (single)

SELECT: count(*)
FROM: #_kunena_thankyou
WHERE: viewer_id = {user_id}

but dont work.

greetings

Please Log in to join the conversation.

12 years 1 month ago #190679 by softforge
Replied by softforge on topic Re: MySQL Field Type Plugin
Try adding 2 underscores after the #

I have change your example below:

datamat wrote: hi,

how can i map to the kunena total thanks?

im using: (single)

SELECT: count(*)
FROM: #__kunena_thankyou
WHERE: viewer_id = {user_id}

but dont work.

greetings


If you like our plugins, please consider writing a review on the Joomla Extension Directory or the Community Builder Directory ...

Please Log in to join the conversation.

12 years 1 month ago - 12 years 1 month ago #190690 by datamat
Replied by datamat on topic Re: MySQL Field Type Plugin
good morning,

still dont work.





if it will work....does it count the thanks of a single user or does it shows the total stats of kunena?

the kunena sql field = jos_kunena_thankyou
SELECT *
FROM `jos_kunena_thankyou`
LIMIT 0 , 30

inside:
vollständige Textfelder 	postid 	userid 	targetuserid 	time
	Bearbeiten 	Löschen 	34 	63 	62 	2012-02-07 13:35:57
	Bearbeiten 	Löschen 	34 	64 	62 	2012-02-07 17:45:01
	Bearbeiten 	Löschen 	40 	62 	64 	2012-02-07 17:57:08
Attachments:

Please Log in to join the conversation.

12 years 1 month ago #192373 by blackforce
Replied by blackforce on topic Re: MySQL Field Type Plugin
Hello SoftForge,
Is this plug in compatibel with CB1. / J2.5?
Listing in the directory doesn't mention it, but hope it is as I love your plug in!

Please Log in to join the conversation.

12 years 3 weeks ago #192886 by blackforce
Replied by blackforce on topic Re: MySQL Field Type Plugin
Hello again :)

I've upgraded successfully pretty everything on a local copy of my site to Joomla 2.5.

However, following the instrcutions to update CB, it says to run the "Check CB database" tool. When I do this, I get this error:

There are 1 column(s) missing in the comprofiler table, which are defined as fields (rows in comprofiler_fields):

- Field cb_groups - Column cb_groups is missing from comprofiler table.

This one can be fixed by deleting and recreating the field(s) using components / Community Builder / Field Management.
Please additionally make sure that columns in comprofiler table are not also duplicated in users table.


cb_groups is the field where I'm using the MySQL Field plugin, so I'm assuming I can ignore that message (your plugin doesnot create a DB entry right?), but can you please confirm?

Thank you very much!

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.324 seconds

Facebook Twitter LinkedIn