Connection problems

[bkpie]

Not sure why I am having connection problems but here is what I have done

In server I have tried www.mysite.com/ as well as just the ip address of our website if I do not use the / then it just shows my own personal ip. In config.php it is localhost.


In user ID I have 2 users with full access to the oscmax database and have tried both. I used the same one as in the config.php file to access it.

Password. Put in our password also the same one in the config.php

database Put in our database also the same one in our config.php
In Cpanel it adds your username to the beggining of your database and I have tried with and without. username_mydatabase and just mydatabase

error I get when it says it cannot connect to database is.
Object Reference is not set to instance of an object.

So where Am I messin up. Thanks

[michael_s]

It could be a couple of things.

First, the hostname could be any of these:

1.yourdomain.com
2.Your IP address at your web host
3.Your web hosts server name that houses the mysql server.

It would never be www.yoursite.com, as xShop does not connect via the web/http. It uses a direct mysql connection over a different port.

As for the database name and username, you must use the full cpanel database and username. That means like this:

cpaneluser_username
cpaneluser_databasename

And finally, in cpanel, you have to also allow remote access to your database. In the Databases section of cpanel, look for a link or icon called Remote Hosts. You need to add the ip of your computer as an access host.

You can get your ip here:
WhatIsMyIP.com

[bkpie]

Michael:

Thank you the remote host took care of it. Now 2 more questions. First I get an error when I click Product Catalog.

"Unhandled exception has occured in your application. Conversion type "DBNull" to Type "long is not valid." Then you can click continue and get nothing or close the program.

Also in the parts that work I did not see where I could change prices for the customer groups we added. Thanks. It looks promising.

[aaron_s]

Do you get the error when you click on Product Catalog (Store Manager->Product Catalog) or when you click on a product within the catalog?

If it when you click on Product Catalog for the first time, I think it might be that you have NULL values for manufacturers (manufacturer_id in the products table)

To get past this error, you can either enter manufacturers for all products, or you can edit the products table and add a 0 for all of the manufacturer_ids that are set to null.

Do you see any products if you click on Quick Update Products?
Are there any manufacturers listed?
If you click on the Manufacturer drop-down, do you see any values?

If you don't see any manufacturers, you can add a manufacturer (Store Manager->Manufacturers) and then go back into the Quick Update Products and and then set the manufacturers.

This will allow you to view the Product Catalog. I will make sure to get a fix into xShop so that NULL values will not cause this error.

-Aaron

[michael_s]

Originally Posted by bkpie

Also in the parts that work I did not see where I could change prices for the customer groups we added. Thanks. It looks promising.

On the product page in xShop, you edit the group price. See the attached screenshot. I have highlighted the area where the price is updated in yellow.

[bkpie]

Thanks Michael I just can't get to the product page. I am going to try Aaron's fixes to see if I can get it to work.

[michael_s]

I tested Aaron's suggestion and it works. It seems that .Net does not allow null values. I blanked out two of my manufacturers fields in the product table and I was able to reproduce your issue with the unhandled exception. As soon as I put in a value, I could see everything fine. It should get you working.

[bkpie]

Nope..Same error

Here is the log
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at SasProducts.clsSasProducts.SaveQuickUpdateProductL istUDT(ConnectionUDT udtConnection, QuickUpdateProductListUDT udtQUPL)
at SasProducts.frmProductQuick.k(Object A_0, EventArgs A_1)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(Eve ntArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(Eve ntArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(M ouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.MenuStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
xShop
Assembly Version: 0.1.0.0
Win32 Version: 0.1.0.0
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/xShop.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
SasCore
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasCore.DLL
----------------------------------------
SasConnection
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasConnection.DLL
----------------------------------------
C1.Win.C1Chart
Assembly Version: 1.0.20033.13147
Win32 Version: 1.0.20033.13155
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/C1.Win.C1Chart.DLL
----------------------------------------
C1.Common
Assembly Version: 1.0.20031.116
Win32 Version: 1.0.20031.117
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/C1.Common.DLL
----------------------------------------
SasData
Assembly Version: 1.0.2750.38773
Win32 Version: 1.0.2750.38773
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasData.DLL
----------------------------------------
CoreLab.MySql
Assembly Version: 3.55.21.0
Win32 Version: 3.55.21.0
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/CoreLab.MySql.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.26 (RTM.050727-2600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
SasProducts
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasProducts.DLL
----------------------------------------
SasManufacturer
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasManufacturer.DLL
----------------------------------------
SasTaxes
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasTaxes.DLL
----------------------------------------
C1.Win.C1FlexGrid
Assembly Version: 2.1.20031.104
Win32 Version: 2.1.20033.136
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/C1.Win.C1FlexGrid.DLL
----------------------------------------
SasFTP
Assembly Version: 1.0.2752.36649
Win32 Version: 1.0.2752.36649
CodeBase: file:///C:/Program%20Files/SASoft,%20Inc/xShop%20osCMax%20Trial%20Edition/SasFTP.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[aaron_s]

I see from the error that you were trying to perform a save on the Quick Update Product screen.

When you were on the Quick Update Product Screen, did you see your products?
Did you have Manufacturers?
Did you have categories?
Was there any information missing?

It looks like the main culprit would be the manufacturer_id, but if that isn't the problem, it looks like it could also be your categories. Are all of you products assigned to categories?


-Aaron

[bkpie]

Yes I see products, categories etc. Manufacturer and tax are blank. I tried to add manufacturer ID as you stated with the drop down and using the fill down command then I got the error. I tried same with tax

[michael_s]

What version of mysql?

Is this a stock database or are there modifications to it.

Is it a osCMax RC3.x database or is this an older version of osCMax 2 (like rc1 or rc2?).

Can you export the database structure and post it as a zipped .sql file (or just paste the sql as code)? I don't need any data, just the structure, as I want to compare it to find the problems.

[bkpie]

Stock
Oscmax RC3
I copied structure and will paste in private email and attach complete database that has been backed up.

[michael_s]

I looked at your database and it is not stock osCMax 2.0 RC3. Stock means completely unmodified.

Your database is modified with changes to the orders table structure and address_book structure. You have also added a lot of new tables to the database (will not cause problems).

The big thing is that you have added about 10 new fields to the orders table and one new field to the address_book table. I have PM'd the database differences to you and to Aaron to look into my findings and to see if that is the source of the issue.

[michael_s]

I found the problem and the fix for you. For anyone else with this specific issue, until we get the next release out to error trap this issue, you can get up and running with xShop with the following change to the products table. Before changing structure in your database, be sure to make a full backup of your database first. You can NEVER be too safe.

alter table `products` ,change `manufacturers_id` `manufacturers_id` int (11) DEFAULT '0' NOT NULL;

Also, xShop handles all your changes to the orders table without any problems whatsoever.

[bkpie]

Thanks Michael. That worked. See my PM for my other suggestions so we can leave this thread for others with this problem

[jewls]

Originally Posted by michael_s

It could be a couple of things.

First, the hostname could be any of these:

1.yourdomain.com
2.Your IP address at your web host
3.Your web hosts server name that houses the mysql server.

It would never be www.yoursite.com, as xShop does not connect via the web/http. It uses a direct mysql connection over a different port.

As for the database name and username, you must use the full cpanel database and username. That means like this:

cpaneluser_username
cpaneluser_databasename

And finally, in cpanel, you have to also allow remote access to your database. In the Databases section of cpanel, look for a link or icon called Remote Hosts. You need to add the ip of your computer as an access host.

You can get your ip here:
WhatIsMyIP.com

I too cannot connect. I have the following set up:

jewelsbyjewls.com (have tried the IP address and the hosting company servername as well)

I have the database name listed with the cpanelusername_databasename and cpanelusername_password

I have set my IP address as the remote access...nothing is working, I get the following error:

[SasData.GetMySQLDataSet] [5] : Table 'jewelsby_storefront.configuration' doesn't exist

[xShop] Object reference not set to an instance of an object.

I'm thoroughly confused...help???

[bkpie]

Instead of Jewelsbyjewls.com use the IP address that when you put it in your address bar it takes you to your site

In cpanel under mysql databases scroll to Access Hosts and enter the IP address of your computer this is different than the above one.

Then cpanelusername_databasename
Then just password not with cpanelusername as you listed first.

See if that doesn't get you going.

[jewls]

I misspoke myself about the cpanelusername_password, I meant cpanelusername_database name.

I have done what you said above and still nothing. I got the following error:

[SasData.GetMySQLDataSet] [5] : Table 'jewelsby_storefront.configuration' doesn't exist
226,68,196,43,138,234,185,155,160,164,46,233,24,17 4,33,194,134,244,20,94,151,72,84,14,39,126,1,114,1 48,197,75,52,86,236,172,84,182,90,148,94,38,70,79, 103,187,76,143,88,91,4,202,166,121,71,80,252,88,39 ,171,16,109,94,186,226,78,158,159,196,32,44,110,86 ,71,15,78,154,187,190,4,223,36,179,246,120,243,97, 108,246,21,251,90,97,40,159,58,248,130,95,196,57,2 26,119,93,184,49,52,165,94,111,216,119,195,26,241, 188,132,5,76,242,158,32,239,69,224,222,111,161,131 ,20,122,231,2,75,202,113,35

[bkpie]

addendum So not to confuse

Server IP address you can type in the web bar and it takes you to your site

User ID = Cpaneluser_username
If your cpanel userid is widget and your username is sam then it would be widget_sam

Password is whatever your password is without cpanelusername

Database is cpaneluser_databasename example widget_jewlsdb

Dont forget the access IP your computer IP. in cpanel Mysql database

[bkpie]

Oops I posted before I got your reply. It is obviously looking for a table that is not in your database. I think this would be something for
Michael or Aaron Sorry I could not go furthur

[michael_s]

Julie, what site are you trying to connect to? Perhaps I can troubleshoot if you send me the url.

[michael_s]

Oh, I see, Jewelsbyjewls.com is the site.

The problem is this:
Powered by Zen Cart

Your site is using Zen Cart not osCMax. xShop does not work with Zen Cart. It works with osCMax.

[jewls]

Originally Posted by michael_s

Oh, I see, Jewelsbyjewls.com is the site.

The problem is this:
Powered by Zen Cart

Your site is using Zen Cart not osCMax. xShop does not work with Zen Cart. It works with osCMax.

No I was starting a new store...the zen cart is there for the time being. I created a totally new database, so not to interfere with the Zen Cart.

This is the info I have created:

Site: www.jewelsbyjewls.com

database name: jewelsby_storefront (the zen cart database is store)
password: I know it...
database username: jewelsby_jbjadmi

for the IP address of the website, I'm at a loss...I have my own hosting and when I look at the IP address of 69.73.139.28 it just tells me that Apache is installed on the system. I have tried our tech support to find out what the exact IP address is for each of the sites I host, but they've been no help.

I also saw that when I click that IP address in my WHM for my site, I get a link that looks like this, http://69.73.139.28/~jewelsby/ so I tried that, and that didn't work either.

What has me puzzled is that when I try connecting it gives me an error message saying [SasData.GetMySQLDataSet] [5] : Table 'jewelsby_storefront.configuration' doesn't exist To me that indicates that the database wasn't created? Am I missing something?

[jewls]

Originally Posted by michael_s

Oh, I see, Jewelsbyjewls.com is the site.

The problem is this:
Powered by Zen Cart

Your site is using Zen Cart not osCMax. xShop does not work with Zen Cart. It works with osCMax.

I just realized what you said...do I have to have osCMax installed???? (feeling REALLY dumb now!)

[michael_s]

Yep, xShop is a windows based store manager for osCMax. Without osCMax installed, there is nothing for it to manage

[jewls]

Ok I feel REALLY stupid now!!

So - the database that I create for osCMax will be the same database for xShop?

Julie

[michael_s]

xShop connects to an osCMax database, so you must have a working osCMax installation in order to use xShop. See the requirements here:

What do I need to use xShop?
What is xShop? What is osCMax? What is osCommerce?
http://forums.sasoft.org/f9/how-do-i...et-up-xshop-2/

[michael_s]

Originally Posted by jewls

No I was starting a new store...the zen cart is there for the time being. I created a totally new database, so not to interfere with the Zen Cart.

database name: jewelsby_storefront (the zen cart database is store)
password: I know it...
database username: jewelsby_jbjadmi

Ok, that is good to know. You have a new database for osCMax. Did you actually run the installer for osCMax and have a working store we can visit? If you do not have a working installation of osCMax, all you have is an empty database with no information in it. That is why you get the error message from xShop. It is trying to connect and get the configuration table , and it is not there.

Originally Posted by jewls

for the IP address of the website, I'm at a loss...I have my own hosting and when I look at the IP address of 69.73.139.28 it just tells me that Apache is installed on the system. I have tried our tech support to find out what the exact IP address is for each of the sites I host, but they've been no help.

I also saw that when I click that IP address in my WHM for my site, I get a link that looks like this, http://69.73.139.28/~jewelsby/ so I tried that, and that didn't work either.

You should be able to use 69.73.139.28 or jewelsbyjewls.com as the server name. Both are acceptable.

Originally Posted by jewls

What has me puzzled is that when I try connecting it gives me an error message saying [SasData.GetMySQLDataSet] [5] : Table 'jewelsby_storefront.configuration' doesn't exist To me that indicates that the database wasn't created? Am I missing something?

This means that xShop is connecting correctly to the right database, but the database is missing the configuration table. Again, if you did not run the installer for osCMax, then all you have is an empty database with no data in it, thus the error.

[jewls]

I installed osCMax, everything is working just fine now...got xShop working, and all is happy in this world LOL

[michael_s]

Julie,

That is great to hear!