Hi Brian,
=20
to have access to your videodb sources would be great, because I=92m not =
able
to produce the same problem at my place.
=20
But please keep in mind that I would need access for at least 1 week,
because I=92m doing the debugging during my work time and I only can =
spend
time, I normally would wait for other processes to become ready.
=20
Please add another admin-User to your vdb and tell me the login =
information.
I promise I will not edit you existing content!
=20
Please don=92t forget to send the access information directly to my mail
address and not to the mailing list!
=20
Best Regards,
=20
Chinamann
=20
=20
-----Urspr=FCngliche Nachricht-----
Von: videodb-devel-admin@...
[mailto:videodb-devel-admin@...] Im Auftrag von Brian
Sorensen
Gesendet: Samstag, 25. Juni 2005 20:20
An: videodb-devel@...
Betreff: Re: AW: AW: [videodb-devel] Database Problem - SQL syntax
=20
Hi Chinamann (and all you others reading this mail-list)
I have an entry with a GuestID =3D 10000, so the update-script worked =
fine.
I've updated output.php and the error is gone just like you said it =
would.
The problem now is that there is still no movies shown in the list. The
dropdown rightly says "All", but this is the only selection in the =
dropdown.
If I press the button all the movies is shown, and the dropdown is =
rightly
showing both users (Gitrian & Guest)
If you are interested I can set up a ftp-webinterface so you can have =
access
to the videodb-files (like Andi suggested).
/ Brian
----- Original Message -----
From: Chinamann=20
To: videodb-devel@...
Subject: AW: AW: [videodb-devel] Database Problem - SQL syntax
Date: Thu, 23 Jun 2005 14:58:52 +0200
Hi Andi,
=20
I've added the '' in "core/output.php" and the error should not occur =
again.
=20
But this is not the real problem!
=20
$_COOKIE['VDBuserid'] in output.php seems to be empty in Brains case.
Before including output.php the index.php includes functions.php.
=20
Inside functions.php we check the authentication with this:
=20
// check authentification data for multiuser
if (basename($_SERVER['PHP_SELF']) !=3D 'login.php') authcheck();
=20
So because index.php is not login.php we jump to authcheck()
=20
There the following lines should take care, that even guests will have =
the
cookies VDBusername, VDBuserid und VDBpassword set.
=20
// autologin as guest?
if (!$result && !$config['denyguest'])=20
{
// get script folder for cookie path
$subdir =3D substr($_SERVER['PHP_SELF'], 0,
strrpos($_SERVER['PHP_SELF'],'/')) . '/';
$result =3D runSQL('SELECT name, passwd FROM '.TBL_USERS.'=20
WHERE id =3D '.$config['guestid']);
setcookie('VDBusername', $result[0]['name'], null, $subdir);
setcookie('VDBpassword', $result[0]['passwd'], null, $subdir);
setcookie('VDBuserid', $config['guestid'], null, $subdir);
$result =3D true;
}
=20
So after this, there should never happen a $_COOKIE['VDBuserid'] =3D=3D =
=91=92.
=20
I tried to force the same error here in my test vdb environment but the
$_COOKIE['VDBuserid'] is always filled with the guests uid and not =
empty.
=20
@Brian: Could you check your database, if you have an entry inside your
config-table which looks like this?:
=20
opt | value
----------------
guestid | 10000
=20
Maybe the upgrade script failed or am I blocked in mind?
=20
~ Chinamann
=20
=20
=20
=20
-----Urspr=FCngliche Nachricht-----
Von: videodb-devel-admin@...
[mailto:videodb-devel-admin@...] Im Auftrag von =
Andreas
Goetz
Gesendet: Donnerstag, 23. Juni 2005 09:12
An: videodb-devel@...
Betreff: RE: AW: [videodb-devel] Database Problem - SQL syntax
=20
Chinamann,
=20
Would adding '' help to solve the problem? Obviously we can't rely on =
having
a user id?
=20
Andreas Goetz
cpuidle@...
http://www.cpuidle.de
=20
=20
-----Original Message-----
From: videodb-devel-admin@...
[mailto:videodb-devel-admin@...] On Behalf Of Brian
Sorensen
Sent: Donnerstag, 23. Juni 2005 09:06
To: videodb-devel@...
Subject: Re: AW: [videodb-devel] Database Problem - SQL syntax
=20
Hi again
=20
The SQL error comes everytime I enter the site in a new browser-window.
=20
I have only one user in my VideoDB (beside Guest) and all the movies is
attached to that user.
=20
When a guest enter the site the person is logged in as a guest and the =
list
is show=EDng the Guest's movies (which is none)
=20
You can check out the site at gitrian.dk/dvd
=20
/ Brian
=20
=20
=20
----- Original Message -----
From: Chinamann <chinamann@...>
To: videodb-devel@...
Subject: AW: [videodb-devel] Database Problem - SQL syntax
Date: Mon, 20 Jun 2005 19:21:57 +0200
=20
>=20
> Hi Brian,
>=20
> I tried to fix the sql error problem you received first. It's now=20
> inside the cvs tree, but you don't have to update, because the fix=20
> should only help the next person wich is upgrading.
>=20
> The other problem you reported, that you have to switch to ALL to see=20
> you movies, is because they are owned by no user. (The old way to make =
> them visible by guest.)
>=20
> No it's a good time to make a backup of your database :-)
>=20
> If backup is done continue reading here:
>=20
> To make it more comfortable you can login as your admin and activate=20
> the "Show tools" checkbox inside you general configuartion tab. Next=20
> you have to go to the "Tools" tab and call the "Transfer ownerless =
movies
to a user"
> contrib module. There you are able to transfer those movies to one of=20
> you users (for example guest).
> Afterwards you have to go to Configuartion->UserManagement->Guest
> Permissions and give the Guest-User readaccess to the Users files you=20
> transferted the moves before.
>=20
> For example if you transferred them to user "Guest" you have to set=20
> "Guest"s Permissions to access his it's own movies...
>=20
> Regards,
>=20
> Chinamann
>=20
>=20
>=20
>=20
>=20
> -----Urspr=FCngliche Nachricht-----
> Von: videodb-devel-admin@...
> [mailto:videodb-devel-admin@...] Im Auftrag von=20
> Brian Sorensen
> Gesendet: Samstag, 18. Juni 2005 19:26
> An: videodb-devel@...
> Betreff: [videodb-devel] Database Problem - SQL syntax
>=20
> Hi
>=20
> I have just upgraded to the latest csv version, and the first time I=20
> enter the site this error pops up:
>=20
> You have an error in your SQL syntax; check the manual that=20
> corresponds to your MySQL server version for the right syntax to use=20
> near '' at line 1 SELECT permissions FROM users WHERE id =3D ;
>=20
> If I afterwards do a refresh the error dissapear and the site is=20
> showing almost normally.
>=20
> The only difference is that I am only seeing the videos of the Guest=20
> (which is none), and I have to select All in the dropdown.
>=20
> What have I missed ?
>=20
> / Brian
>=20
>=20
>=20
> --
> ___________________________________________________________
> Sign-up for Ads Free at Mail.com
> http://promo.mail.com/adsfreejump.htm
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies =
> from IBM. Find simple to follow Roadmaps, straightforward articles,=20
> informative Webcasts and more! Get everything you need to get up to=20
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=3Dclick
> _______________________________________________
> videodb-devel mailing list
> videodb-devel@...
> https://lists.sourceforge.net/lists/listinfo/videodb-devel
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies =
> from IBM. Find simple to follow Roadmaps, straightforward articles,=20
> informative Webcasts and more! Get everything you need to get up to=20
> speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=3Dclick
> _______________________________________________
> videodb-devel mailing list
> videodb-devel@...
> https://lists.sourceforge.net/lists/listinfo/videodb-devel
=20
=20
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
=20
=20
=20
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=3Dick
_______________________________________________
videodb-devel mailing list
videodb-devel@...
https://lists.sourceforge.net/lists/listinfo/videodb-devel
=20
=20
=20
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=3Dclick
_______________________________________________
videodb-devel mailing list
videodb-devel@...
https://lists.sourceforge.net/lists/listinfo/videodb-devel
--=20
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=3Dsignup
<http://mail01.mail.com/scripts/payment/adtracking.cgi?bannercode=3Dadsfr=
eejum
p01>=20
|