News:

Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - wzrd

#1
PasteBin / Re: SQL error
Jan 13, 2009, 01:52 PM
Yep, no more $errors..
But is the same thing, the pastes goes to the forum but not to the pastebin.
No recent posts
No output when i click to the number of the post that i made 1 sec a go.
Seems to don't want to work..
Well i'm gona wait for the SMF 2.0 final..
Thank you for your time :)
______________________________________
EDIT
-------------------------------------------------------------------
I'v just installed smf 2.0 beta 4 (just a fake forum) for supporting the pastebin
Work just fine now.
Thanks.
#2
PasteBin / Re: SQL error
Jan 12, 2009, 06:49 PM
Hi,
Sorry for the second post .
I removed 2 lines (remove the smf 2.0 arrays) the line 491 & 508 (of your index.php) & now the pastebin is not displaying anymore warnings, or Notifications.
Seems to be fine , & the url-s after i edit my .htaccess file are working great.
I have just ONE problem to fix.
The pastebin it's fine when i post the code it post it on the forum (eg board 23) but when i click to the number of the paste it's display the following error message:

You have attempted to pull a paste from a board which is not setup for pastes. Please check your Paste number and try again

The message of the incorrect_board
& it's not showing the pastes history.
Help me, i'm not a php geek.
#3
/*Ushtrim i thjesht ku mbledhim 3 numrat e pare, i zbresim te katertin dhe
 * shohim rezultatin
 */
import java.util.Scanner;
public class Mbledhje {
   public static void main (String args [] )
   {
      Scanner input = new Scanner (System.in);
      //Fillojm edhe thjesht therrasim disa variabila pa u dhene vlerat
      int a;
      int b;
      int c;
      int d;
      int rezultati;
      System.out.println("**********************");//per estetik
      System.out.print ("Fut numrin e pare:");
      a = input.nextInt();
      System.out.print ("Fut numrin e dyte:");
      b = input.nextInt();
      System.out.print ("Fut numrin e trete:");
      c = input.nextInt();
      System.out.print("Fusim numrin e fundit:");
      d = input.nextInt();
      rezultati = ( a + b + c - d );
/*Rezultati ne kete rast eshte nje menyre per zgjedhjen e problemit dhe me te
 * mund te bejm shume lloje veprimesh si + , - , / , * , mjafton te ndryshojm
 * shenjat tek rezultati dhe mund te kontrollojm veprimet.
 */
      System.out.printf("Rezultati eshte %d\n", rezultati);
      System.out.println("**********************");//per estetik
   }
   
}
#4
PasteBin / Re: SQL error
Jan 12, 2009, 03:44 AM
Thank you for your reply
We are all most there
Now it's working (no more sql error) & it gives me the paste but now we have an error on
Undefined variable: file in /fullpath/pastebin/index.php on line 491
I'v just make a paste but it gives me 404 not found the same when i click credits (but must be something with the .htaccess file) /yep it was the .htaccess file but what is the correct path, it gives me a 500 internal error.
PS
I see the paste on the board forum but i don't see it on the pastebin
#5
PasteBin / SQL error
Jan 11, 2009, 06:57 PM
Hi there, first of all it's just a great script, and i really love it.
Sow keep it up :)
Second, i'm using smf 1.1.7  :) with wordpress (different db)
sow
root dir /wordpress/
smf dir /wordpress/smf
pastebin dir /wordpress/pastebin
And i'm using a non default template but there is no problem with the paths and the settings file.. (i think)
When i go to the pastebin/index.php
It gives me the following error..
Notice: Undefined variable: file in /fullpath/pastebin/index.php on line 487
And this is the sql error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}topics AS t
WHERE t.ID_BOARD = {int:paste_board}
ORDER BY id_last_msg DES' at line 2


PS, i'm not using english language, but i'v just modified the language/index.english.php file

Can we fix this error ?