| 
Welcome, Guest

TOPIC: MySQL Field Type Plugin

Re: MySQL Field Type Plugin 1 year 3 months ago #190624

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 administrator has disabled public write access.
The following user(s) said Thank You: akasharkbow

Re: MySQL Field Type Plugin 1 year 3 months ago #190639

  • datamat
  • datamat
  • OFFLINE
  • Senior Boarder
    Senior Boarder
  • Posts: 52
  • Karma: 1
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
Last Edit: 1 year 3 months ago by datamat.
The administrator has disabled public write access.

Re: MySQL Field Type Plugin 1 year 3 months ago #190679

  • softforge
  • softforge
  • OFFLINE
  • Expert Boarder
    Expert Boarder
  • Posts: 135
  • Karma: 10
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...
The administrator has disabled public write access.

Re: MySQL Field Type Plugin 1 year 3 months ago #190690

  • datamat
  • datamat
  • OFFLINE
  • Senior Boarder
    Senior Boarder
  • Posts: 52
  • Karma: 1
good morning,

still dont work.

query2.jpg


query3.jpg


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
Last Edit: 1 year 3 months ago by datamat.
The administrator has disabled public write access.

Re: MySQL Field Type Plugin 1 year 3 months ago #192373

  • blackforce
  • blackforce
  • OFFLINE
  • Fresh Boarder
    Fresh Boarder
  • Posts: 11
  • Karma: -
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!
The administrator has disabled public write access.

Re: MySQL Field Type Plugin 1 year 2 months ago #192886

  • blackforce
  • blackforce
  • OFFLINE
  • Fresh Boarder
    Fresh Boarder
  • Posts: 11
  • Karma: -
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!
The administrator has disabled public write access.
Time to create page: 0.220 seconds