Advanced Search

Search Results (Searched for: joomla)

Today 02:41
Adding Kunena topics via SQL injection was created by antifm

Adding Kunena topics via SQL injection

Category: General questions and how-tos

I have kunena installed for some time now into Joomla but there is another section of the site i would like to tie to it. Its essentially a list of topics that exist outside of the Joomla function. To import or inject these topics into Kunena, I would need to go into my PHPAdmin panel on the server and run a few SQL commands.
Ok no problem there but as i am trying to do the, i keep getting something funny and i think its because of my understanding of the Kunena Topics SQL table columns.
So maybe someone can help me clarify them.

I have over 3,000 topics i need to add into Kunena and here is what i did.
I went into the PHPAdmin area and downloaded an sql copy of the "xx_kunena_topics" table. I can use this as a template to write additional topic IDs and their needed information.
xx_kunena_topics has COLUMS with the following names and most of them, i know what they represent. But there is a couple which i am wrong about. I need to know what the colums are looking for.

Below i have typed up my understanding of each of the comumn ROWS but 3 of them i think i am getting incorrect when i creat my write up my SQL INSERT command.

fist_post_id 
last_post_id
last_post_time

The reason that i said if you have 100 topics, you dont nessasarily have 100 topics in your SQL table. If you created a topic and its ID was 100 but then deleted the topic, when you create another one, it becomes 101. It does NOT take the place in the system becoming
topic ID number 100 
and
last post ID 100

So i think thats where i am going wrong. I was able to test this by creating TWO lines of SQL INSERT commands that would create 2 topics into a specific category FROM the PHPadmin area.
I ran the code, and SUCCESS!
I see on the front end that the two topics are created correctly in the right area, with appropriate name and ID in the URL
but when i click them:
first it kept showing the BODY of the very first TOPIC so i corrected that.
Then it created it with the right topic + ID + URL+  everything else, however because of the TIMESTAMP i applied for
first_post_time
last_post_time
It told me i dont have access to the message. I believe this is also related to the FIRST and LAST post_id) Keep in mind, the post ID is relative to HOW MANY ACUTAL POSTS were created INCLUDING any deleted topics.

So my questions are below.




id - topic id number (the first topic created would be id = 1) If there is 100 topics, the last one would NOT be 100 however and below you will see why.
category_id = category ID number from the categories admin area. I am working with category number 9
subject = The text of the subject of topic name.
icon_id = denotes WHICH icon your topic uses. I have NO topic icons so this is 0
label_id = As above. This is 0
locked = These will not be locked. So this is 0
hold = Not on hold so this is 0
ordering = no particular ordering so this is 0
posts = I believ this means HOW MANY POSTS or REPLIES are tied to this topic. I am creating new topics sothis is 0
hits = the number of times this topic has been clicked to view
attachments = None so this will be 0
poll_id = As above so this is 0
moved_id = this was not moved from another category so this is 0
first_post_id = WHAT IS THIS ASKING FOR?
first_post_time = The number of seconds since Jan 1st 2021 to the time of this topic created
first_post_userid = User Id of the person creating the post
first_post_message = The BODY of the topic.
first_post_guest_name = the USERNAME tied to that USER ID
last_post_id = WHAT IS THIS ASKING FOR?
last_post_time = Is this the same as FIRST_POST_TIME ?

last_post_userid = again the USER ID tied to the USERNAME for this post
last_post_message = Same as first_post_message
last_post_guest_name = Sane as first_post_guest_name
rating = I am not using RATING so this is 0
params = this is blank
24 Feb 2021 18:57
Replied by Maago on topic Umfrage Symbol ausgegraut

Umfrage Symbol ausgegraut

Category: German

ok, hab jetzt mal eine ganz neue Joomla Installation gemacht als Test. Dort gleich Kunena installiert .. dort funktioniert es.
Seltsam ... also hat es nicht primär etwas mit dem Produkt zu tun, sondern mit meiner Installation??
23 Feb 2021 12:54
Replied by rich on topic Kunena 5.2.2 Profile Error

Kunena 5.2.2 Profile Error

Category: K 5.2 Support Archive

The Kunena Clean template is only an example template and not ready for use. You can use it,  if you want to create your own template. Use Crypsis instead (or Crypsisb3 b4) depending on your Joomla template.
23 Feb 2021 10:51
Kunena 5.2.2 Profile Error was created by rickozaccess

Kunena 5.2.2 Profile Error

Category: K 5.2 Support Archive

Hi, 
Nothing happens when I click on any of the folowing tabs in the 'Profile' section.
Subscriptions, Favorites, Unapproved, Attachment Manager, List Of Banned Users


This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct

Joomla! SEF: Disabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 16M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : AS 002090 | author: AS Designing | version: 1.5.0 | creationdate: 2016-01-24

Kunena default template details : Clean | author: Kunena Team | version: @[email protected] | creationdate: @[email protected]

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
| Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None


Thank you
 
22 Feb 2021 21:22
Replied by rich on topic problem with update and modules

problem with update and modules

Category: Installation issues

I don't know this weather module. Disable it and then try to install Kunena via the Joomla installation manager. The best way is the installation routine via URL.
20 Feb 2021 16:02 - 20 Feb 2021 16:04
how to hide buttons in editor? was created by carsten888

how to hide buttons in editor?

Category: General Questions Archive

There are just soooo many buttons in the editor (just click reply and you'll see). I would only like to show only a few on my forum. How to hide the buttons which are useless on my forum?

I have checked the configuration and disabled things like soundscloud- and ebay-embedding. But it still shows that button.
I checked the wiki, and searched this forum but found no answer.

joomla  3.9.24 
Kunena 5.2.2

 
13 Feb 2021 20:01
Replied by xillibit on topic Content Encoding Error - "invalid or unsupported form of compression"

Content Encoding Error - "invalid or unsupported form of compression"

Category: Installation issues

Hello,

Do-you have enabled gzip compression on Joomla configuration or in your Joomla tempalte params ?
13 Feb 2021 16:51 - 14 Feb 2021 14:16
Replied by AndrewF on topic 5.2.2 no poll/voting function after update

5.2.2 no poll/voting function after update

Category: K 5.2 Support

Hello
please see attached version.
Thank you
This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 2M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : protostar | author: Kyle Ledbetter | version: 1.0 | creationdate: 4/30/2012

Kunena default template details : Crypsis | author: Kunena Team | version: 5.2.2 | creationdate: 2021-01-13

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
| Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None

  
10 Feb 2021 19:18
Undo and Redo buttons not working... was created by feliwebwork

Undo and Redo buttons not working...

Category: K 5.2 Support

This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
       

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 300 seconds | Max execution memory: 512M | Max file upload: 256M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : Favourite | author: FavThemes | version: 3.3 | creationdate: September 2012

Kunena default template details : Crypsis | author: Kunena Team | version: 5.2.2 | creationdate: 2021-01-13

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None


For some reason the undo and redo buttons are not working after the Kunena 5.2.2 upgrade and ctrl+z is also not working.

Any ideas?
10 Feb 2021 11:49 - 10 Feb 2021 11:49
Replied by xillibit on topic Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4

Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4

Category: K 5.2 Support Archive

Hello,

Do-you checked in your Joomla! template if there are options for optimize JS ?
10 Feb 2021 09:12
Replied by swillig on topic Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4

Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4

Category: K 5.2 Support Archive

Thank you for your quick reply.

There is no page optimization (tool) active or installed.
Caching mode in Joomla is disabled.
The only thing - gzip was endabled, but disabling makes no difference.

Any other idea?
09 Feb 2021 11:38
Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4 was created by swillig

Problem loading CK Editor / Kunena 5.2.2 / Crypsisb4

Category: K 5.2 Support Archive

Hi there,

I have a problem with Kunena 5.2.2 / Joomla 3.9.24 and the Crypsisb4 Template and the ckeditor.

If i want to start a new topic, the ckeditor does not load an on debugging console I get the following error:
ckeditor.js:547 Uncaught TypeError: Cannot read property 'split' of undefined
    at Object.loadPart (ckeditor.js:547)
    at l (ckeditor.js:284)
    at a.<anonymous> (ckeditor.js:283)
    at a.l (ckeditor.js:10)
    at a.<anonymous> (ckeditor.js:12)
    at a.CKEDITOR.editor.CKEDITOR.editor.fire (ckeditor.js:13)
    at a.fireOnce (ckeditor.js:12)
    at a.CKEDITOR.editor.CKEDITOR.editor.fireOnce (ckeditor.js:13)
    at k (ckeditor.js:281)
    at Object.<anonymous> (ckeditor.js:281)


I assume that there is a conflict, but I don't get with wat.
There are no modules loaded, which do any other javascript except of the joomla core plugins/modules/header.

Here is my config report:
This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
        

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 90 seconds | Max execution memory: 1000M | Max file upload: 10000M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : VFT 2018 | author: S. Willig | REIKEM | version: 1.0.0 | creationdate: Oct 2018

Kunena default template details : Crypsisb4 | author: Kunena Team | version: 5.2.1 | creationdate: 2020-12-27

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None


The Forum is private so I cannot give public access to this.

Has anyone an idea what I can do?
 
08 Feb 2021 18:22
Replied by SBott on topic Problems after updating to 5.2

Problems after updating to 5.2

Category: K 5.2 Support

Hi,
no - I'm sorry, that's not it...
I have set the Kunena "display captcha" option to "nobody", the field "captcha challenge for users" is empty (was set to "0" before).
In the main Joomla config, "standard captcha" is set to "no selection".
The captcha plugins "recaptcha" and "invisible recaptcha" are both deactivated. As per the linked thread I also deactivated "easycalcplus" plugin.
Then emptied cache, tried again, but the exact same things happen (logged in as admin):
"New topic" or "Actions - Answer" displays the list of topics, but the new topic or answer have not been posted.
"Quick reply" leads to a 404 message.
There are no pending messages on the index page of the forum.
08 Feb 2021 17:22 - 08 Feb 2021 17:33
K 5.2.2 Editor & Preview Not Functioning was created by Christophg

K 5.2.2 Editor & Preview Not Functioning

Category: K 5.2 Support

Hello...

After upgrading from 5.1.7 to 5.2.2 the editor is missing the "Preview" Button.
Also, no matter how many times I hit "Enter" to creat a space / paragraph between text and images or video, it shows in the Edit Mode but not after submission.
There are no Joomla menu conflicts that I am aware of. The only one on the site directed to Kunena is Aliased. Please advise.

Thanks ... Christoph

 
 
 

This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |
       

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 120 seconds | Max execution memory: 768M | Max file upload: 256M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : protostar | author: Kyle Ledbetter | version: 1.0 | creationdate: 4/30/2012

Kunena default template details : Crypsis | author: Kunena Team | version: 5.2.2 | creationdate: 2021-01-13

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: Kunena Latest 5.1.2

07 Feb 2021 05:39
Nonsensical Birth Dates was created by KZQ

Nonsensical Birth Dates

Category: K 5.2 Support

All of a sudden my members birthdates have gone crazy. Some members have the correct date others have tomorrow's date, some even have "01/01/-0001" as a date.
Any advice will be appreciated.
Bill


This message contains confidential information

Database collation check: ✔ The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
       

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 300 seconds | Max execution memory: 256M | Max file upload: 256M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : js_wylia2 | author: Joomlashack | version: 2.2.17 | creationdate: November 26 2020

Kunena default template details : Blue Eagle5 | author: Kunena Team | version: 1.5.2 | creationdate: 2018-12-11

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 5.2.2 | 2021-01-13 [ Iris ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: UddeIM 4.0

Third-party SEF components: None

Plugins: None

Modules: None

Displaying 1 - 15 out of 41768 results.
Time to create page: 2.671 seconds