Royally Confused Myself

I made myself a word document with a workflow of sorts to make sure I don't forget anything while creating an ecommerce site I am working on. I am getting close to the end and things aren't working the way they should. I will list what I think has problems and such:


Things that work:

Registration - database has all data in it - (registration.php)

Email to user to verify email (except email labels say "RegistrationFormUserName" instead of "UserName"



Things that don't work:

I don't know how to setup the admin username and password to get into the back end of the site to add products, edit users, view orders, etc. I have all the admin pages created in a folder with page access limited to the Ultimate user.

I can't see my downloads folder in the page manager to password it so you can't just type in the url to download for free.

The verify email address email goes to a page that says:
"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 'l= '-1' AND users.UserRandomString <> '0'' at line 1" (also, I am developing on a subdomain right now and originally the link went to the normal address and not the subdomain)

The login, on submit, goes to the CMS admin login. - I created a user in the database called Test with password of Test123. (login.php ) Or it will try to use the admin login and add this url "admin/admin_login.php?accesscheck=%2Fv2%2Fadmin%2Fproducts_search.php%3F" I did just try to search for something in the admin area. But then I went back to the site home and clicked login, input my information, and it still goes to that other link.


I went in and manually changed the user email verified from 0 to 1, and if I try to log in, it works. I gain access to the areas I specified as verified user only. If it doesn't work, it is because the login submits to a different form.

I also took off the page rules everywhere else so I could at least test adding a product to the data base and such. I can add a product, view it, change it, in the admin section and it all seems to be working (except for product images, i still need to iron out).

Public product search (products.php) returns an error : Fatal error: Call to a member function GetContent() on a non-object in D:\hosting\9062558\html\v2\products_results.php on line 6




And that is about all the further I can get right now as I need to have the registration, verification, admin login, user login, completed before adding products manually and viewing everything through the admin area. I still have to code a download center and an admin dashboard that has dynamic charts for users, page hits, sales, etc. I also have to figure out sub categories and dynamically display categories on the search page and the insert product page.

I believe it boils down to having tutorials for the older versions of the extensions and not having links to the proper tutorials on the workflow guide.

If you need any information, please let me know. The site is still "blank" so feel free to rummage around the files --- v2.leonardolampwork.com

I also could have forgotten to do some steps, with how confused I am right now, I don't know where to start debugging this thing. I need all the help I can get. I want to get it all working first, then i will make it appealing to the eyes.

To unscramble the mess above here is a starting point for me.

I figured out how to grant access to email verified users. I now need to get the random string in the email, to be verified on the site, and then automatically update the user to verified. For the time being, I get the error stated above.

I cannot figure out how to grant access to a user with a level of "4" to the admin pages. I would think it is the same process to update the emailverified from 0 to 1, but just for checking the UserLevel if 4 or not. I found some user level authentication pdf's but they looked old and didn't really help.

I will search more later on how to get the show region to show the appropriate message for the appropriate user clicking a certain part of the website they don't have access to.

Can't seem to get the images pulled correctly from the database. All i see are broken image icons.

The public (guest) product search leads to an error. (as stated above)

Sometimes the login works, sometimes it doesn't. It seems to be a cookie error as it likes to go the admin pages if I have page restriction rules active.

(if you can help me out here, that would be great, this is mostly a remembering post for myself. Pointing me to other threads would be great to save both of our times)

For the email verification, see the Tutorial on the Data Bridge support page for Creating a double opt in registration system:
data-bridge/


For user level authentication, there is a tutorial in the Archived Documentation section of the Security Assist Support page. It was written For Security Assist v1, but the concept is exactly the same in data Bridge / Security Assist v2.

The 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 'l= '-1' AND users.UserRandomString <> '0'' at line 1"


seems to indicate that the where clause uses "!=" for a not equals condition where it should be "<>" for mysql.


the error:
Fatal error: Call to a member function GetContent() on a non-object in D:\hosting\9062558\html\v2\products_results.php on line 6

will happen on pages that use eCart where the GetContent() function is before the require_once() line to include the cart object.

for dynamic images, makes sure you include the path to the image folder in the img tag:

<img src="path/to/images/<?php echo $row_recordsetName['columnName'] ?>" />

I figured out the email verification problem.

Where it said this ""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 'l= '-1' AND users.UserRandomString <> '0'' at line 1""

The "l=" was actually a spelling error in the Recordset (reverify). I typed it "emai l=" instead of "email=".

I will work on the rest. Thanks

When I copy the image url generated by the search results, I only get the path to the image folder and the image name is not appended:

"http://v2.leonardolampwork.com/product_images/thumb/" is what I get, but I need "http://v2.leonardolampwork.com/product_images/thumb/image_thumb.png"

The image source on the results page is "../product_images/thumb/<?php echo($row_WADAproducts['ProductThumb']); ?>"

The ProductThumb column is set to VARCHAR(100), Not Null, Default (blank) . In dreamweaver insert pages I have it as type="file" , id is ProductImage and it is set to an Upload Files server behavior. I checked and the images are making it to the proper folders, and being resized to the alloted sizes.

I went to check the Upload Files (ProductImage) binding to see if that was doing anything, and I got a SUPER long list of bindings for it. It seems that it created new bindings everytime I tried editing the image thumbnail to be a dynamic link:

photostream/

Each image uploaded gets put in a "main", "thumb", and "xl" folder. Main is for on detail pages, thumb is thumbnail, and xl is for a blown up view on detail page. And I have 5 images per product detail page.

Another update. I went and looked at the ProductThumb column, and all the fields are blank. Same as the ProductImage fields.

I then went to look at the Insert Record (products) on the admin products_insert.php page, and found that the ProductImage column has a type of "Text", and a value of "<?php echo ($WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"]); ?>" . The ProductThumb has a type of "text" and a blank value.

So I figured out how to get the insert and update field to post the filename to the database. The correct valuefor the ProductThumb column in the bindings tab for the Insert Record (products) server behavior is: "<?php echo $WA_DFP_UploadStatus["WA_UploadResult7"]["WA_UploadResult7_2"]["serverFileName"]; ?>". This was the "Server File Name" binding with the images folder path before it. So the binding said ../product_images/thumb/[FileName]_thumb (61): Server File Name.

Yes, where you have multiple uploads and they are saving multiple versions of the image, you need to be carefull of which bindings you select to get the right one.

I am following the applying datasist to insert and update pages pdf and I am on the update page. After I make the original field hidden and create a new file field, I am choosing the Default Value Lightning Bolt, it says to find WADAupdateform option and then choose the field I set to hidden earlier. I cannot find the WADAUpdateForm option. Is this just an outdated method and I should just get rid of the hidden field and have the file field submit to my database for each specific size image?

Sorry to keep bombarding this thread, I just need to make sure I have all my problems and solutions documented for my future websites.

With the issue of the update page not updating the database... Here is my file update area:

photostream/

And I am just trying to have the first file field (id=ProductImage7 the hidden field is ProductImage6) update the productimage in the database. In the Update Record (products) server behavior, this is the binding I am selecting. It most likely is wrong since there are a hundred other ones that look the same. I understand that for each file field there will be a set of bindings for each image size I am having created, but I don't know what to make of this stuff:

photostream/

I have the admin insert product page working flawlessly, so I figured it would be the same thing here, but I choose the same bindings as I did before, and set the default file to the hidden field, and all it does it delete the record for ProductImage and leave the column blank.

The only update fields not working are the file fields. Price, name, etc all update correctly.

i think we need to determine why you are creating so many variations of each image


I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.