Support Forums - All Posts - XOOPS Web Application System

Forum Index

Board index » All Posts (mjoel)

Bottom

« 1 ... 3 4 5 (6) 7 8 9 ... 28 »

Re: SQL error with Tag Module

2019/11/13 0:03
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

still have this error in the index page (no tags are listed) and top page where top tag block is activated


0.000475 - SELECT DISTINCT(o.tag_id), o.tag_term, o.tag_status, SUM(l.tag_count) AS count, l.tag_modid FROM tag_tag AS o LEFT JOIN tag_stats AS l ON l.tag_id = o.tag_id WHERE (o.tag_status = '0') GROUP BY o.tag_id ORDER BY count DESC LIMIT 0, 50

Error number: 1055

Error message: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxxx.l.tag_modid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]

Topic | Forum

SQL error with Tag Module

2019/11/7 6:22
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Hi..
Im using tag module 2.34RC2 downloaded from herehttps://github.com/XoopsModules25x/tag/
XOOPS Version XOOPS 2.5.10
PHP Version 5.6.40
mySQL Version 5.7.28

no tags are listed in index and blocks.. i received this sql error in debug message


SELECT DISTINCT(o.tag_id), o.tag_term, o.tag_status, SUM(l.tag_count) AS count, l.tag_modid FROM tag_tag AS o LEFT JOIN tag_stats AS l ON l.tag_id = o.tag_id GROUP BY o.tag_id ORDER BY count DESC LIMIT 0, 100



Error message: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxx.l.tag_modid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Topic | Forum

Re: Trouble with Publisher 1.07

2019/10/30 4:36
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Quote:

mjoel wrote:

2. editing any current article does not have any problem but I'm having problem creating new article after submit i received the message "Sorry. It was not possible to update the article!"

i managed to solved this problem

1. Go to Publisher Preferences
2. enable the Show Development Tools Button
3. Click Migrate Tab . Click Show SQL > Do Migration > Write Schema

Topic | Forum

Re: wgGallery 1.10 ready for testing

2019/10/27 12:43
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Quote:

goffy wrote:
hi mjoel

i found the problem. can you please download current version fromhttps://github.com/ggoffy/wggallery

the import from extgallery is now working..thank you..

Topic | Forum

Re: Trouble with Publisher 1.07

2019/10/27 12:39
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

I tried adding at front end and back end ..i got the same weird error

Still tyring to figure out this problem

Topic | Forum

Re: Trouble with Publisher 1.07

2019/10/23 8:56
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

i solved the problem number number 1

all the categories i set my username to be the moderator of the categories

i manually set it all back to 0 in phpmyadmin table


UPDATE `xx_publisher_categories` SET `moderator` = '0'

i don't have this problem in publisher 1.05

still trying to figure out problem #2

Topic | Forum

Re: wgGallery 1.10 ready for testing

2019/10/23 2:15
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Hi

thanks for this module..great work so far

i downloaded the latest revision from github...i tried to import from my existing extgallery module ..im using eXtGallery 1.13 RC1

i have more than 10 albums and hundred of images but nothing is display

Resized Image

i received this error after submit

MySQL-Error: Unknown column 'ec.cat_text' in 'field list'

Topic | Forum

Trouble with Publisher 1.07

2019/10/23 2:01
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Hello xoops...i need help on using Publisher 1.07

XOOPS Version XOOPS 2.5.10
PHP Version 5.6.40
mySQL Version 5.7.28

i recently update my xoops from 2.5.9 to 2.5.10 and the publisher module from publisher 1.05 to 1.07 all is going well except

1. i can't access the category in publisher admin .. i receive 500 error.. i have more than 10 categories

2. editing any current article does not have any problem but I'm having problem creating new article after submit i received the message "Sorry. It was not possible to update the article!"

some solutions that i have tried clean cache...redone all the permission setting and clone my publisher module and copy all the data to the clone module..same problem

turning on debug does not return any related error

Topic | Forum

Help with extcal mysql table

2019/1/31 4:47
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

Hello XOOPS

Im using a modified extcal module ..where i dont want to set time and i want to use only date for event....i would like to update my existing extcal database ...

so that event_start and event_end field of extcal module to have 00:00:00 time

as example from 2012-11-14 08:00:00 to 2012-11-14 00:00:00

the problem is in extcal event_start and event_end are originally in int format


SELECT `event_start`,`event_end` FROM `xxx_extcal_event`

i use this query to convert event start and event end to a readable date using this query


SELECT FROM_UNIXTIME(`event_start`),FROM_UNIXTIME(`event_end`) FROM `xxx_extcal_event`

i tried something like to update the time but its not working


UPDATE `xxx_extcal_event` SET FROM_UNIXTIME(`event_start`)=concat(FROM_UNIXTIME(`event_start`), ' 00:00:00'), FROM_UNIXTIME(`event_end`)=concat(FROM_UNIXTIME(`event_end`), ' 00:00:00')

after update event_start and event_end should be back in int format

how do i do this help.. im using phpmyadmin

Topic | Forum

Re: verify registered user in html

2018/12/24 3:20
mjoel
Quite a regular
Posts: 325
Since: 2006/12/9

use this


global $xoopsUser; 

if (!is_object($xoopsUser)) {

    redirect_header('index.php', 3, "You have no permission");

}

check also
https://xoops.org/modules/newbb/viewtopic.php?topic_id=77168

Topic | Forum

Top

« 1 ... 3 4 5 (6) 7 8 9 ... 28 »

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: SQL error with Tag Module

SQL error with Tag Module

Re: Trouble with Publisher 1.07

Re: wgGallery 1.10 ready for testing

Re: Trouble with Publisher 1.07

Re: Trouble with Publisher 1.07

Re: wgGallery 1.10 ready for testing

Trouble with Publisher 1.07

Help with extcal mysql table

Re: verify registered user in html

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}