Geek Help

[Phil Lilley]

My tech guy is under the weather for a few days.  There's a problem with search and IPS has given me the answer but I don't know how to implement the solution.

I have to do this:

While editing a group, you may not be able to save the group, and a message displayed indicating that you need to "Enter a value greater than 0." To resolve this issue, run the following query (be sure to adjust for your table prefix):

update core_groups set g_dname_date=1 where g_dname_changes=0 AND g_dname_date=0

And then run the Support Tool to clear caches. Once done, upload the attached file to /applications/core/extensions/core/GroupForm/

I don't know much about databases but I did find core-groups and the settings in question.  But this command -

set g_dname_date=1 where g_dname_changes=0 AND g_dname_date=0

doesn't make any sense to me.  Ideas?

What's it mean to adjust table prefix?

I have the file to upload to /applications/core/extensions/core/GroupForm/

[rps]

It would be so much easier if they used English.

[Quillback]

I think I know enough on this to be dangerous.  I THINK the table prefix in the "g" in front of the dash in the table names, as in g_dname_date=1.  Your table may have a different prefix than "g" and you have to adjust the command accordingly replacing the g with whatever the prefix is.  So look at the table Core Groups and see if the table names are different, if so you have to change the prefix in the command for dname_ date=1, dname_changes=0, and dname_date=0.

 

Maybe it's labled as wp_dname_date = 1. for example, in your database.

I'd recommend doing a backup before making any table name changes.

I'll see if I can find someone that knows SQL to see if they'll take a look at this.  A SQL savvy type would know the answer to this right off the top of their head.

[DaddyO]

Phil,

Message me and I'll be happy to help.  Also, if you can tell me what type of Operating System (Windows or Linux) and what database (SQL Server, Oracle, MySQL) is being used.  I'll either need remote access to your system, or I'll have to walk you through the changes over the phone.

[BilletHead]

    This is why I like the folks you have on your Forum Phil ,

BilletHead

[Phil Lilley]

Thanks!  PM Sent.