Search found 102 matches

by crusi
Wed Dec 12, 2012 8:09 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL query multiple select table
Replies: 6
Views: 1128

Re: SQL query multiple select table

HGN wrote:Try this (using brackets to enclose the SELECT's):
Hello HGN,

many thanks for your help.
Its working. I had also to add the 'ORDER BY' within the brackets that the 'LIMIT Query' gets the correct value from the table.
by crusi
Mon Dec 10, 2012 8:07 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL query multiple select table
Replies: 6
Views: 1128

Re: SQL query multiple select table

How do you store the date? Apparently the EVENT_DATE field is of type varchar. You need to convert the date to unixtime and store it in a field of type int(11) to be able to sort and compare them correctly. Hello HGN, thanks for this good tip. Its much easier with UNIX-Time and working like a charm...
by crusi
Sun Dec 09, 2012 8:39 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL query multiple select table
Replies: 6
Views: 1128

Re: SQL query multiple select table

HGN wrote:How do you store the date? Apparently the EVENT_DATE field is of type varchar.
You need to convert the date to unixtime and store it in a field of type int(11) to be able to sort and compare them correctly.
Yes, its a VARCHAR field.

Currently its stored like:
2012.12.01
2012.11.11
...
by crusi
Sun Dec 09, 2012 5:02 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL query multiple select table
Replies: 6
Views: 1128

SQL query multiple select table

Hi all, I have the following problem: I have two tables: TABLE_A and TABLE_B . In both tables I have dates from appointments. I like to select all the dates from both tables and display them ORDERED By ASC together in one simple list. To build this query for one table is very easy... but how can I q...
by crusi
Wed Dec 05, 2012 10:58 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Using a variable in SQL WHERE Query is not working?
Replies: 2
Views: 129

Using a variable in SQL WHERE Query is not working?

Hi all, I try to do the following: $current_date = "05-12-2012"; $sql = 'SELECT * FROM ' . TABLE_EVENTS . ' WHERE event_date = ' .$current_date; or $current_date = date("d-m-Y"); echo $current_date; //Output: 05-12-2012 what is correct for my use $sql = 'SELECT * FROM ' . TABLE_EVENTS . ' WHERE even...
by crusi
Tue Nov 27, 2012 11:44 am
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

RMcGirr83 wrote:phpBB3 Chmod Permissions

but I bet your server was compromised so if it was me I would change all the passwords for FTP, cpanel etc.
many thanks for the link.
Of course I will change all passwords including database and so on...
Many thanks to all.
by crusi
Tue Nov 27, 2012 11:19 am
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

I know it's a bit of a last resort - did you try re-installing PHPBB? Maybe you should backup your database first though. Trouble with that is if the problem files are on the server any new phpBB installation could be infected as well. Also, a new install would mean needing to reinstalling all the ...
by crusi
Sun Nov 25, 2012 7:15 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

RMcGirr83 wrote:The cache folder permissions should be set to 777.
done, but still the same problem :(
by crusi
Sun Nov 25, 2012 3:24 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

Your board is some phpBB-Magic fork? Many of your board files are renamed to magic-xxxxx.php. 3. If you clear the cache the whole phpbb3-Board is not working any more. What exactly does "Clear the cache" means? Is it clearing the cache from the ACP or removing all files from the cache folder using ...
by crusi
Sun Nov 25, 2012 3:09 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

You can remove all files from the cache folder except .htaccess and index.htm . Could you tell what exctly the problem is you are currently facing, because it is not clear for me what the current status is. The problem is: 1. Search results from my phpbb3-Board on google are redirected to "http://u...
by crusi
Sun Nov 25, 2012 2:51 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

The error was probably due to the missing cache folder. The log files I was referring to would be on your hosting, cPanel or whatever other control panel you host provides. Have you reported this issue to your hosting company? It is possible that the server itself has been compromised rather than j...
by crusi
Sun Nov 25, 2012 2:35 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

You shouldn't delete the entire cache folder. Try replacing the cache folder with just the index.htm and .htaccess files in it. A blank screen is usually caused by a suppressed php error so check your logs. I am not able to find any errors regarding this issue. I copied now some cache files from my...
by crusi
Sun Nov 25, 2012 2:16 pm
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

I have deleted the cache folder from my webiste... And now the website is not working any more... If I now enter the address from my site all what I get is a white screen... I already replaced the most important files in my eyes: config.php, index, and all other files in that root folder. Any ideas ...
by crusi
Sun Nov 25, 2012 7:52 am
Forum: [3.0.x] Support Forum
Topic: Very strange search problem (from google, or hyperlink)
Replies: 23
Views: 1166

Re: Very strange search problem (from google, or hyperlink)

stevemaury wrote:Please fill out the Support Request Template Generator and post it back here to enable us to assist you better.
Thanks for your reply.
I have filled out the Support Request Template.
by crusi
Sun Nov 25, 2012 7:39 am
Forum: [3.0.x] Support Forum
Topic: Very strange search problem with phpbb3 Board from google
Replies: 1
Views: 259

Very strange search problem with phpbb3 Board from google

Support Request Template What version of phpBB are you using? phpBB 3.0.10 What is your board's URL? http://www.tischtennis-schiltach.de Who do you host your board with? giga-hosting.biz How did you install your board? I used the download package from phpBB.com What is the most recent action perfor...

Go to advanced search