Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

MySQL Field Type Plugin

12 years 10 months 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 or Create an account to join the conversation.

  • datamat
  • datamat
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 1
12 years 10 months ago - 12 years 10 months 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
Last edit: 12 years 10 months ago by datamat.

Please Log in or Create an account to join the conversation.

  • softforge
  • softforge
  • OFFLINE
  • Posts: 129
  • Thanks: 21
  • Karma: 12
12 years 10 months 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 or Create an account to join the conversation.

  • datamat
  • datamat
  • OFFLINE
  • Posts: 26
  • Thanks: 0
  • Karma: 1
12 years 10 months ago - 12 years 10 months 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
Code:
SELECT * FROM `jos_kunena_thankyou` LIMIT 0 , 30

inside:
Code:
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:
Last edit: 12 years 10 months ago by datamat.

Please Log in or Create an account to join the conversation.

12 years 10 months 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 or Create an account to join the conversation.

12 years 9 months 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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum